split row data and insert a symbol

Question

1.00/5 (1 vote)

See more:

Hello
please write query
table name is : abctable
my data to update in below formate
actual data-
R06E310.0N
R06E310.0V
R06E315.0N
R06E315.0V
R06E320.0N
R06E320.0V
R06E35.5N
R06E35.5V
R06F31.0N

wants to update like this-
R06E3-10.0N
R06E3-10.0V
R06E3-15.0N
R06E3-15.0V
R06E3-20.0N
R06E3-20.0V
R06E3-5.5N
R06E3-5.5V
R06F3-1.0N

so please write a query for this.

Thanks
Shubham Gupta

Posted 16-Feb-15 19:24pm

Member 11449483

Add a Solution

Comments

Peter Leow 17-Feb-15 1:33am

What have you tried? Where are you stuck?

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

/\jmot · Accepted Answer · 2015-02-16T19:37:00

Solution 1

SQL

update abctable set columnName=
substring(columnName,1,5)+'-'+substring(columnName,7,len(columnName)-5)

ref.
https://msdn.microsoft.com/en-us/library/ms187748.aspx[^]

Posted 16-Feb-15 19:37pm

/\jmot

split row data and insert a symbol

1 solution

Solution 1

Add your solution here

Preview 0

split row data and insert a symbol

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us