Post reply

REPLACE more than 1 character string in a field

  • January 8, 2003 at 4:03 pm

    #79434

    I've been trying to use REPLACE to update multiple strings in a field but only the first one will work, i.e.

    Declare @m char (100)

    Select

    @m, replace ( FieldA, '+', ' '),

    @m, replace ( @m, '%2E', '.'),

    Can anyone suggest any other way of trying to do this, or tell me what I am doing wrong?

  • January 8, 2003 at 4:07 pm

    #445897

    Are you wanting this?

    SELECT replace(replace(FieldA, '+', ''), '%2E', '.')

    Looks like you want 4 outputs, if the above does not meet your needs then what are you starting with and what do you want to be the final result?

  • January 8, 2003 at 6:47 pm

    #445907

    quote:

    Are you wanting this?

    SELECT replace(replace(FieldA, '+', ''), '%2E', '.')

    Looks like you want 4 outputs, if the above does not meet your needs then what are you starting with and what do you want to be the final result?

    Thanks I'm new to this, but that does the trick.

Viewing 3 posts - 1 through 3 (of 3 total)

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