Search for names containg the ' char 2

[Boorgy]

Hi again,

Ok, the thing I forgot to mention is that I am using SQL in a VB6 application. Now the "O'Connor" thing doesn't work, no more than using brackets and lots of other things I've tried...
So if you have the answer, or if you know someone who's likely to, please help!!!

Boorgy

 

[MichaelRed]

The Source Table:

ContributorID ContLastName ContFirstName
1 Doe John
2 Smith Roberg
0 Mary O'Conner

The Sql Statement:
SELECT tblContributitor.ContFirstName
FROM tblContributitor
WHERE (((tblContributitor.ContFirstName)="O'Conner&quot);


The Query Results:

ContFirstName
O'Conner

All of which should be able to be done in any valid SQL situation. MichaelRed
mred@att.net

There is never time to do it right but there is always time to do it over

 

[tlbroadbent]

Try using two single quotes in the place of the single quote in the name - O''Connor. Don't use double quotes if you are connecting with ODBC.

Check these articles.

http://www.vbtt.com/tips/erroneous_single_quotes_reek_havoc_with_sql_queries.html

http://www.vbonline.com/vb-mag/9706/article/api.htm

Terry Broadbent
Please review faq183-874.

"The greatest obstacle to discovery is not ignorance -- it is the illusion of knowledge." - Daniel J Boorstin