I have a varchar field like:
x
195500
122222200
I need to change these values to:
1955.00
1222222.00
Advertisement
Answer
If you want to add a ‘.’ before the last two digits of your values you can do:
SELECT substring(code,0,len(code)-1)+'.'+substring(code,len(code)-1,len(code))
FROM table1;