Hi Alan
Thanks for this great function. One note:
SELECT * FROM dbo.PatExclude8K('123# What?!... ', '[^a-z!?.]')
returns hat?!...
So it is case sensitive, contrary to your comment in the programmers notes. I guess this comes from the Latin1_General_BIN collation.
To get the result as expected, I can use
SELECT * FROM dbo.PatExclude8K('123# What?!... ', '[^a-zA-Z!?.]')
Matthias Kläy, http://www.kcc.ch