I need to detect when a record is insert and updated in a character based field if the field has any special characters, particularly an apostrophe and remove them?
If you provide a comprehensive list of the special characters (or ASCII codes) that you want stripped, Dagon or I (or both) will be happy to provide code that does all the stripping you need.
Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.