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.
can you try this .......select NAMEfrom TABLE_NAMEwhere NAME LIKE '%''%';
Silva I tried '%''%' it is not working
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