laika222
10/27/2016 - 6:26 PM

Replaces certain substring text with other substring text of your choosing. Line 1 introduces the REPLACE() function, telling it to look at

Replaces certain substring text with other substring text of your choosing. Line 1 introduces the REPLACE() function, telling it to look at the Company column, search for the substring 'ai', and replace it with the substring 'zz'.

SELECT REPLACE(Company, 'ai', 'zz')   
FROM Orders4;