Hi,
I was thinking of creating a stored procedure that would detect any records in the typical tables (T_Customer, T_Address, T_Phone, T_Eaddress) with characters symbols where they dont belong, and generally inappropriate characters like tab and return etc.
Has anyone come across a report like this already? I appreciate any advice before I get started inventing the wheel here.
Aaron,
With Tessitura we provide a procedure called UP_FIND_INVALID_CHARACTERS that looks for ascii characters 1-31 or 127.
The main Constituent tables are covered in this proc but you can always create a local version to add more tables.
If @fix_data is set to 'Y' this actually fixes the data. It should be run repeatadly until no additional errors are returned by the proc.
Dale
> With Tessitura we provide a procedure called UP_FIND_INVALID_CHARACTERS
Very helpful; as per your suggestion I made a version that looks at T_ORDER custom fields when we were having an issue with those.
On the topic of non-printable characters, when I just want to see what's in a field before I optionally fix it, I've found the function shared here to be very helpful:
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=164618