hi, how do i validate a userid to ensure
they are 3 uppercase digits followed by
6 digitals, otherwise it will reject it.
ABC123456 - OK
abc123456 -NOT OK
ab12345 -NOT OK
12abc -NOT OK
I'm thinking of using substring to test for the 6
digits to ensure it is between 1-999999,
not sure if that works, anyone can assist?
they are 3 uppercase digits followed by
6 digitals, otherwise it will reject it.
ABC123456 - OK
abc123456 -NOT OK
ab12345 -NOT OK
12abc -NOT OK
I'm thinking of using substring to test for the 6
digits to ensure it is between 1-999999,
not sure if that works, anyone can assist?