I think you need to parse your ID_no and only replace the relevant characters if I understand the situation. (i.e. ID_no 12A3 would become 1213, and 12Z3 would become 12263.)
Take a look at the BOL entry for ASCII.
--Michael
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.