counting digits for a number field.

  • Thread starter Thread starter aeyo
  • Start date Start date
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
 
Aeyo,

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