>Cetin,
>Example:-
>lcstring = "Lee's ABC Store,USA" (Sometimes could be double quote)
>spt = sqlexec(lnhandle,"select * from tablename where field like %"+lcstring)
>Problem caused both by the comman and single quote.
>Yau

Use parameters as I said and it won't be a problem.

lcstring = "%Lee's ABC Store,USA" && (Sometimes could be double quote)
* or:
* lcString = [This has " and ' in it]
spt = sqlexec(lnhandle,"select * from tablename where [field] like ?m.lcstring","myResult")

Cetin