The script in this post fixes a typo, in the Fabrikam sample database, in the Tax Schedule Description whereby the h in Purchases was missing. Not a big thing, but I was working on a report which was configured to return the Description as well as the Tax Schedule ID and it was bugging me.
Hence a script to fix it, so I can easily fix it again in future.
/* Created by Ian Grieve of azurecurve|Ramblings of a Dynamics GP Consultant (http://www.azurecurve.co.uk) This code is licensed under the Creative Commons Attribution-NonCommercial-ShareAlike 2.0 UK: England & Wales (CC BY-NC-SA 2.0 UK). */UPDATE ['Tax Schedule Header Master'] SET TXSCHDSC = REPLACE(TXSCHDSC, 'Purcase', 'Purchase') FROM TX00101 AS ['Tax Schedule Header Master'] WHERE TXSCHDSC LIKE '%Purcase%'