how to find digit counts in a number value
Actually my requirement is check below condition :
If STD ZIP5 is a 5 digit value, then STD CM ZIP is equal to STD ZIP5, else null.
for this i wrote a SQL Statement as
len(TB_MS_DZD_EB_ACCT_CNSL_SCD.STD_ZIP5) = 5 and TB_MS_DZD_EB_ACCT_CNSL_SCD.STD_CM_ZIP is not null then pass else fail.
but my manager told its "Testing for 5 characters, requirements state 5 digits ".
can any one clarify me where i did wrong??