Smooshing - The act of removing all non-alphanumeric characters from a string.
We have found several areas of our application where we need to perform cleaning on strings. The following is a SQL function which can be used to remove any non-alphanumeric characters.
To use the function create the script and then SELECT dbo.fn_SmooshIt('B?\RU.,C>}E') will result in 'Bruce' being selected.
2007-10-02 (first published: 2002-06-20)
15,451 reads