>I am needing to do a SPT to find part numbers that have a % in them. Since this is the wildcard symbol haw would I write the sql string?
SELECT * FROM YourTable WHERE ATC([%], TheField) # 0 INTO CURSOR crsTest
And because you mention SPT here SQL Server version:
SELECT * FROM YourTable WHERE CHARINDEX('%', TheField) > 0
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.