March 19, 2012 at 9:27 am
Hello Everyone,
I have one filed in the database for addresses, somehow all addresses stored like eg. '7 station rd,NYPD', could anyone guide me easy way to update the field without '. eg. 7 station rd,NYPD.
Thanks.
March 19, 2012 at 9:34 am
If ALL addresses have the start and end quote, you could do something like this:
select stuff(stuff(MyAddr, LEN(MyAddr), 1, ''), 1, 1, '')
from MyTable
March 19, 2012 at 9:52 am
You are a Super Star!!!! Great!!!
March 22, 2012 at 12:35 pm
The REPLACE function is another option.
March 22, 2012 at 12:55 pm
homebrew01 (3/22/2012)
The REPLACE function is another option.
Only if there are no single quotes within the address field.
March 22, 2012 at 9:03 pm
Reply removed.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply