Solved

comma with period

Posted on 2010-11-10
4
220 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

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Suggested Solutions

I've encountered valid database schemas that do not have a primary key.  For example, I use LogParser from Microsoft to push IIS logs into a SQL database table for processing and analysis.  However, occasionally due to user error or a scheduled task…
When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

747 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now