>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")