Replace a Word in a string 1

[AndrewWiggins99]

How do I replace a specific word in a string using SQL

Example:

This is a test for school.

Replace the 'TEST' with 'BOOK' - This is a BOOK for school.

 

[Beilstwh]

REPLACE('This is a test for school',' test ',' BOOK ')

Bill
Lead Application Developer
New York State, USA