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 (https://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%'