Solved

comma with period

Posted on 2010-11-10
4
224 Views
Last Modified: 2012-05-10
replace a
,
with a
.



is this just
update, set
0
Comment
Question by:rgb192
  • 2
  • 2
4 Comments
 
LVL 10

Expert Comment

by:Mez4343
ID: 34107445
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
 

Author Comment

by:rgb192
ID: 34107576
table1.colum1 has a
,
in it



there is other text

but I just want to replace the , with .
0
 
LVL 10

Accepted Solution

by:
Mez4343 earned 125 total points
ID: 34107733
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
 

Author Closing Comment

by:rgb192
ID: 34108849
thanks
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Recently, when I was asked to create a new SQL 2005 cluster, Microsoft released a new service pack for MS SQL 2005 what is Service Pack 3. When I finished the installation of MS SQL 2005 I found myself troubled why the installation of SP3 failed …
Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

685 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question