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 [...]
Real Life Tech Problems Solved.