>I am trying to disallow special characters in otherwise open varchar fields. I can create a function to do a replace (field,’@’,’’) on each special character for each field, but that would be cumbersome and CPU intensive, and it would change the intended input rather than giving an error message. SQL string functions are limited. I am looking for the best way to do this. Any ideas??

You can use a trigger or CHECK Constraint.