Solved

comma with period

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



is this just
update, set
0
Comment
Question by:rgb192
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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 …
So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
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…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

759 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