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