Skip to content
Advertisement

How can I add a character into a specified position into string in SQL SERVER?

I have a varchar field like:

I need to change these values to:

Advertisement

Answer

If you want to add a ‘.’ before the last two digits of your values you can do:

sqlfiddle demo

User contributions licensed under: CC BY-SA
10 People found this is helpful
Advertisement