With very little documentation I have been trying to figure out how to code reports in C/SIDE and for the most part I have gotten by but I am stumped on one issue:
The variable SSN is for the Social Security Number we added to our Staff table. I need to check each record and report if the SSN isn't valid because of bad formatting or alpha characters. (I can't change the form for various reasons.) Anyway, in VB Script I could just loop through each character in the SSN field and make sure the ASCII value of that character is valid for a number but I can't figure how to make that work in C/SIDE.
Anyone have any suggestions how I can get this work or a better way to validate the value in the field is all numeric?
0
Comments
If SSN includes a checksum character then you can use STRCHECKSUM function.
if also alfa can be used : use this:
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!