Browsing articles in "MSSQL"
Sep
23
2010

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