>>Note that the parameter order is swapped for like() - ie the equivalent query is
>>
>>select * from mytable where like( '?2*', myfield )
>
>Sorry Cetin, meant to post that to Tim rather than reply to you.

:) And this is bad timing. I got this after posted previous.
Cetin