Post reply

Search and Replace in TSQL

  • March 19, 2012 at 9:27 am

    #150846

    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

    #1461190

    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

    #1461204

    You are a Super Star!!!! Great!!!

  • March 22, 2012 at 12:35 pm

    #1462959

    The REPLACE function is another option.

  • March 22, 2012 at 12:55 pm

    #1462972

    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

    #1463143

    Reply removed.

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

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