By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,963 Members | 1,249 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,963 IT Pros & Developers. It's quick & easy.

SQL SUBSTRING causing E_FAIL error - C# using access database

P: 5
I don't know what the problem is with this query. It seems correct, but I guess it is not since it is not working. I'm using access as a database and C# language.

Below is my sql text..

"SELECT priest_id, title + SPACE(1) + firstname + SPACE(1) + lastname + SPACE(1) + substring( middlename, 1, 1 ) as priestname FROM `priest` ORDER BY priestname"

Thanks in advance,
Joe Gan
Apr 21 '07 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.