Clear the Precedent (template) file override field in bulk

SCRIPT to clear the filename override field for the active records and those that don’t have lmdelete.doc in the override field:

Update Precedent_Reg
SET pre_doc_full_name = ''
WHERE pre_active = 'Y' AND  pre_doc_full_name <> 'lmdelete.doc' AND pre_doc_full_name <> ''