Hi Kris;
I am very sure that was my first attempt and it didn't work yesterday, but I have now done exactly this and the statement has parsed. Thanks for looking at it for me.
cheers.
>> I am trying to use the JDBC LIKE escape clause with PG 8.4 and the PG 8.4 JDBC driver.
>> So far I have tried;
>> SELECT ... WHERE ... AND (t0.MESSAGE ILIKE ? {escape '|'}) LIMIT 50
> This works for me as attached. Please be more clear what your problem is.
___
Andrew Lindesay
www.lindesay.co.nz