>Yes, it's all non-numeric. I was looking for an isdigit() and it seems you have given it to me!
>

John,

Not exactly. The ISDIGIT() in SQL would be

... badgeno LIKE '[0-9]%'

The ISNUMERIC() tells if value can be converted into integer, floating, money or decimal data types. See http://www.berezniker.com/display/SQL/IsNumericEx+UDF+-+Data+type+aware for some additional info.