Alfredomulet
MIS
Hello there, thanks for the previous responses. Is it there an easy way to replace one character of a field by 0 (zero) using just SQL?
For example:
TXN_AMT
000024584862R
000000473929J
000000012929A
000005013141S
to
TXN_AMT
0000245848620
0000004739290
0000000129290
0000050131410
The length of the field is allways 13, and the letter to replace is allways the last character on the right.
cheers,
Alfredo
For example:
TXN_AMT
000024584862R
000000473929J
000000012929A
000005013141S
to
TXN_AMT
0000245848620
0000004739290
0000000129290
0000050131410
The length of the field is allways 13, and the letter to replace is allways the last character on the right.
cheers,
Alfredo