>Boris,
>
>
>SELECT * FROM YourTable WHERE ATC([%], TheField) # 0 INTO CURSOR crsTest
>
>
>Will this SPT work if it is MySQL? Basically, what I am asking is if VFP functions (like ATC) can be recognized?
>
>Thanks!
>
>Dennis
Hi Dennis,
Check this link
http://dev.mysql.com/doc/refman/5.0/en/string-functions.htmlIt's INSTR() or LOCATE() in MySQL.
If it's not broken, fix it until it is.
My Blog 
