Home Forums SQL Server 2008 SQL Server 2008 - General Using REPLACE with a string where I need to replace %anystring% with some new string RE: Using REPLACE with a string where I need to replace %anystring% with some new string

  • August 13, 2012 at 10:52 am

    #1525179

    roryp 96873 (8/13/2012)

    Does this not work for you?

    select REPLACE(yourstring '%sometext%', 'replaced')

    from #temp

    I think the point is to replace any text between %.

    --Vadim R.