Like clause in Livelink Reports

[cdfly]

hello,
I am creating a Livelink report that I need to use a LIKE clause in

WHERE subwork_title LIKE '%SOME TITLE%'

This is failing when I try and run the report with a message that says there's an unclosed quotation mark. The sql is is fine because I've tested it in Query Analyzer. Do the % signs need to be escaped?

Thanks

 

[appnair]

Yes something like '%%SOME TITLE%%' note sure if it has to be single or double quotation as well

Well, if I called the wrong number, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937
Certified OT Developer,Livelink ECM Champion 2008,Livelink ECM Champion 2010

http://www.tek-tips.com/faqs.cfm?fid=2884

http://www.linkedin.com/in/appunair

 

[cdfly]

Thanks appnair,
The double percents %% worked