S
sdhi
I have numbers that end in various characters (like 1111A, 1111B, 12221{,
etc.) Each of these ending characters has a one digit number equivalent (like
A=1, B=2, {=0). I need to replace the character with it's numeric equivalent
so the results would be 1111A=11111, 1111B=11112, 12221{=122210. How would I
write one REPLACE query to do this? Or is REPLACE not the right choice?
etc.) Each of these ending characters has a one digit number equivalent (like
A=1, B=2, {=0). I need to replace the character with it's numeric equivalent
so the results would be 1111A=11111, 1111B=11112, 12221{=122210. How would I
write one REPLACE query to do this? Or is REPLACE not the right choice?