Post reply

Need to replace a string in a string with a string

  • February 25, 2003 at 9:56 am

    #159433

    I am trying to replace a string variable within a string in a field as such \\Computername\FTP\<companyname>. I want to exchange the <companyname> and update it with an actual company name. The field type is a varchar and I am just trying to zip through the table and replace all the variables with actual values within that field. Can anyone help with this?

    Thanks,

    Chris

  • February 25, 2003 at 10:15 am

    #449708

    DECLARE @CompanyName VARCHAR(xxx)

    SET @CompanyName = 'Name of Company'

    UPDATE MyTable

    SET MyField = REPLACE(MyField, '<companyname>', @CompanyName)

    WHERE [Criteria go here]

  • February 25, 2003 at 11:46 am

    #449719

    Perfect, it worked great!!! Thanks

    quote:

    DECLARE @CompanyName VARCHAR(xxx)

    SET @CompanyName = 'Name of Company'

    UPDATE MyTable

    SET MyField = REPLACE(MyField, '<companyname>', @CompanyName)

    WHERE [Criteria go here]

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

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