Thank this author by sharing:
By Cade Bryant,
Trim Non-Alpha characters from string
Random 64 Characters alphanumeric String
Powerful function to find strings containing or excluding classes of ASCII characters.
Conversion failed when converting datetime from character string
Find last occurence of a character within a string
As a member of SQLServerCentral, you get free access to loads of fresh content: thousands
of articles and SQL scripts, a library of free eBooks, a weekly database news roundup,
a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals
that makes it such a success.