Mike.Mander

Search for attribute that contains single apostrophe

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

Hi,

 

 

 

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.

 

'sinusoid'

 

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

Outcomes