counting digits for a number field.

A

aeyo

Is there a built-in function that could count number of
digits in a field? More specifically I am trying to count
number of digits for SSN and find out wether there are
employees who have less than 9 digit SSNs.

Thanks for your help in advance.
Aeyo
 
S

Steve Schapel

Aeyo,

Would Len([SSN]) serve your purpose? This will return the number of
characters, not just specifically digits.
 
Top