Hi All

It's getting to the end of the day and there is something
that I just dont seem to be able to figure out.

I have a number of address

Example Below

3 High Street, Chester,
4 The Main Road, Liverpool,

and they have trailing comma's, is there a easy way to get
rid of these.

Any help would be great.

Thanks Phil

If you want to get rid of the commas , you can do this

update table set address = replace(address, ','.'')
where address like '%,%'

If you only wanted to get rid of the trailing comma, do this

where address like '%,'

HTH

--
Ray Higdon MCSE, MCDBA, CCNA
---
"Phil" <harlequintp (AT) blazemail (DOT) com> wrote

hi phil,

see following example and use the update statement that has been shown, if satisfies your requirement.

--table/sample data

create table #t(address varchar(50))

--sample rows
insert into #t
select '3 High Street, Chester,' union all
select '4 The Main Road, Liverpool,' union all
select '5 The Main Road, Liverpool1'

--required update statement will be

update #t set address = left(address, len(address) -1)
where address like '%,'


-Vishal