Re: escape character in queries?

Hi
Use ' before ' (apostrophe is escapee for itself) for example
insert into tab( col ) values( 'That''s the question' ) and select *
from tab
where col like 'That''s the question'

Received on Wed Apr 28 1999 - 04:22:42 CDT