• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 234
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

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