Entry

How do I construct select statements where the string in the where clause has an apostrophe? Ex: SELECT * FROM customers WHERE name like 'Bob's%';

Sep 2nd, 2005 19:23
Rohit Kulkarni, Michael Vickers, Jackie Nguyen,

Try using double apostrophes. For instance, in T-SQL:

select idProfile from tblProfiles where strAddS1 like '%''%'

This select statement in one of my SQL Server DB's will return all IDs 
in a particular table where there is an apostrophe somewhere in the 
street address field.

So, for your particular select statement I would try:

SELECT * FROM customers WHERE name like 'Bob''s%'

Good luck.


Michael

--------------------------------
Two single quotes will work in case of PL/SQL too

-Rohit.
--------------------------------