Hi,
Please help.
I am using  VB 6.0 and SQL Server 6.5
Using ADO for the connection.
If I have a name D'Souza in the database, how can I fire a query based on
this criteria?
I used -
rs.open "select * from pub_info where name = 'D'Souza'"

But this didn't work as it got confused in the apostroph used in the name.
How should I query based on these values in the database?
Any help would be appreciated.
Thanks in aniticipation.
Regards,
Purnima

rs.open "select * from pub_info where name = 'D''Souza'"

--
HTH

VB-Joker
MCSE

PLEASE post ALL replies to newsgroup!

Not quite so simple, I'm afraid. I once worked on an application where ships
names had to appear inside double quotes, and sometimes a ship's name had an
apostrophe, e.g. "H.M.S. O'Grady". It was a few years ago, but we never did
find a way around this. (it was a sybase app, but SQL server is not really
any different)

In the end we translated all single quotes into spanish "e"'s, and all
double quotes into something else, before we wrote to the database. Then we
had to translate when we read the data back. Yeuchh! I'd be interested to
see if anyone knows a better way (there must be one!)