Swear word filter on input
Posted on 2004-08-18
Ive got a real hard question for someone to solve....Upon insert of a record into a table, i am using a trigger to check for certain data, one of the things i want to do is to check for swear words, if there are swear words then i want to delete the record...
Does anyone know of a method of setting up perhaps an array of swear words that i can check the input against??? One of my concerns is checking a string against potentially 100/200 swear words, i think this could add a certain amount of strain on the server load, so any suggestions for this too would be very much appreciated.
Thanks in advance guys,