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.
'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