All Forums Database
satya.yandra 2 posts Joined 02/08
05 Feb 2008
Quotation(') in Data to be quaried

I was trying select NAME from TABLE_NAME where NAME '%\'%' ESCAPE '\';The above query not working.I would like to how would we handle quotation in side the data.

joedsilva 505 posts Joined 07/05
05 Feb 2008

can you try this .......select NAMEfrom TABLE_NAMEwhere NAME LIKE '%''%';

satya.yandra 2 posts Joined 02/08
05 Feb 2008

Silva I tried '%''%' it is not working

wood0323 4 posts Joined 11/07
06 Feb 2008

using two single quoteslike '%''%'seems to work. same with insert statements, i.e. insert into table (names) values ('Int''l'); would insert the string Int'l

You must sign in to leave a comment.