• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 233
  • Last Modified:

comma with period

replace a
,
with a
.



is this just
update, set
0
rgb192
Asked:
rgb192
  • 2
  • 2
1 Solution
 
Mez4343Commented:
DECLARE @input varchar(50);
SET @input = '1,2,3,4'
DECLARE @replacethis varchar(1);
SET @replacethis  = ',';
DECLARE @result varchar(50);

SET @result = REPLACE(@input,@replacethis,'.')            
SELECT @result
0
 
rgb192Author Commented:
table1.colum1 has a
,
in it



there is other text

but I just want to replace the , with .
0
 
Mez4343Commented:
You can use an UPDATE statement with the REPLACE lie this:

Update table1
Set  column1 = replace(column1, ',', '.');

Just take a backup of your table before messing around ;-)
0
 
rgb192Author Commented:
thanks
0

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now