Home Forums SQL Server 7,2000 SQL Server Newbies extracting column values when a part of the column value is known RE: extracting column values when a part of the column value is known

  • What to do if we want to replace the word 'good' with 'bad' in all those sentences?

    I wrote it like this:

    REPLACE(columnname,'good','bad')

    Is there any other way to do this?