Re: Cleaning Comments - SQL script
Just while this old chestnut is in my mind.
For those who have difficulty with the rtf formatting in text fields Ive uploaded a script that works across multiple tables and strips text fields of rtf formatting using the UDF functions.
We run these before doing any major outputs to ensure we dont get any conflicts.
See:
http://forums.nbn.org.uk/uploads.php?file=CLEAN_COMMENTS_ALL.txt
Tullie House Museum