findtext="%"+somecharvalue+"%" * I claim both works select * from sometable ; where searchfield like findtext * You said "it can't work" select * from sometable ; where searchfield like (findtext)Now if it was a name expression I would understand why to use parentheses. Here I ask is there something else that I don't know ? Regards.