T sql return on letters only

Create Function [dbo].[RemoveNonAlphaCharacters](@Temp VarChar(1000))
Returns VarChar(1000)
AS
Begin

    Declare @KeepValues as varchar(50)
    Set @KeepValues = '%[^a-z]%'
    While PatIndex(@KeepValues, @Temp) > 0
        Set @Temp = Stuff(@Temp, PatIndex(@KeepValues, @Temp), 1, '')

    Return @Temp
End

Source: stackoverflow.com

Similar codes

7 votes339 views2 answers
Phpmyadmin change password
SQL
0 vote324 views1 answer
Lost connection to mysql
SQL
1 vote302 views3 answers
Postgresql connect to database
SQL
3 votes342 views1 answer
Start mysql server linux terminal
SQL
3 votes306 views2 answers
Pl sql escape '
SQL
2 votes338 views3 answers
Sqlite3.OperationalError: near "7": syntax error
SQL
0 vote323 views1 answer
Mysql select smaller of two values
SQL
3 votes366 views5 answers
No module named 'MySQLdb'
SQL
15 votes333 views4 answers
Mysql export database command line
SQL
2 votes306 views1 answer
Possgress drop if exists table
SQL