Fix precedent (template) names from .doc to .docx where the File Override field has the .docx extension

SCRIPT to fix the active records that are named .doc but are actually .docx:

Update Precedent_Reg
SET pre_type = pre_type + ‘x’
WHERE CHARINDEX( pre_type +'x',  pre_doc_full_name, 1 ) <>0 AND pre_type like '%.doc' AND pre_active = 'Y'