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%'