Some background: I have a table that is being generated on a daily basis. I need to run a few scans on the table to validate the data. One of the these checks involves making sure the social security numbers are ONLY numbers. If it does find a character in one of the fields, then I should get a message box alerting me of the error.

For example, this is something along the lines of what I need to do.

use export
scan
if (any digit of the ssn is not 1 - 9)
wait window "SSN error" at 20,70
endif
ENDSCAN

Any help would be appreciated.
Thanks

Ramone