[castor-dev] Performing a LIKE %xxx% query

[Gray Jones]

Has anybody been able to create a LIKE query that uses wildcards?

I'm trying to do something like select * from policy where text LIKE %xxxx%.
However I get a syntax exception from the %.  Is there a way to surround a
parameter with wildcards?  A way to escape the %?


Thanks,

Gray Jones

----------------------------------------------------------- 
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
        unsubscribe castor-dev