Search for attribute that contains single apostrophe

Discussion created by Mike.Mander on Nov 18, 2011
Latest reply on Nov 18, 2011 by michaelh





I am trying to search for tag names inside the exdesc attribute.  Is there any way to search for the tag name with its opening and closing apostrophe i.e.




contained in


'cdt158' + 'sinusoid'


I have tried


SELECT * FROM pipoint WHERE exdesc LIKE '%''sinusoid''%'       however the OLEDB tester gives a syntax error.




Any help would be great