Real life problems solved

Advert

Replace text in MSSQL row

I just had to do a bulk find and replace in MSSQL on a databsae to change PizzaExpress to Pizza Express. Instead of having to go into each one and change one by one I could just use the following SQL Query. Much faster!

UPDATE restaurants
SET restaurantName = REPLACE(restaurantName ,'PizzaExpress','Pizza Express')
WHERE restaurantName like '%PizzaExpress%'
Adsense