Replace function

Question

Post reply

Replace function

MikeJ-437562

SSC Veteran

Points: 248
More actions
May 7, 2007 at 8:22 pm

#117178

Can any one post an example of how to use Replace method for replacing values of a column?
Address columns has commas to be replaced by a space.
Select LastName, FirstName, Address
from tblEmployee

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Sergiy SSC Guru Points: 110208 More actions · Answer 1

Actually you could just press F1 and type REPLACE in index keyword box.

Would get answer much faster.

REPLACE(AddressString, ',', ' ')

_____________
Code for TallyGenerator

MikeJ-437562 SSC Veteran Points: 248 More actions · Answer 2

but how i can pass the address value? from address column in table.

have more than 300 rows.

SwePeso SSC-Dedicated Points: 39757 More actions · Answer 3

UPDATE Table1

SET Col1 = REPLACE(Col1, ',', ' ')

N 56°04'39.16"
E 12°55'05.25"

Jules Bonnot SSCertifiable Points: 5488 More actions · Answer 4

are you sure there arent any lines of the address that are meant to have spaces in them. So when you spilt the address on space you will cut lines in half. You should be populating another table with a column for each line spilting out the values between the commas.

www.sql-library.com[/url]

Steve Jones - SSC Editor SSC Guru Points: 736270 More actions · Answer 5

If this is a varchar col, this won't help. '' and ' ' are the same.

Can you give a sample of the before and after items in the table?

Both Peter and Jules have given you the right idea.

MikeJ-437562 SSC Veteran Points: 248 More actions · Answer 6

thanks everyone for replies. update column worked perfectly.

Thank you peter.