Being a financial company we were impacted by SOX requirements. Although we were not certified, we had several processes in place that already added to the paperwork burden. However, all...

I have created a function to replace unacceptable characters as below.

This can probably be modified to meet your needs...

IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'FN' AND...