>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
No, but you didn't point what database you used so I just read the header of the message.
And only because you mentioned SPT I did a wild guess about SQL Server :-)
As Christof said you should use your backend syntax when you use SPT.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.