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

6 votes314 views2 answers
Mysql timestamp to date
SQL
0 vote289 views1 answer
EnvironmentError: mysql_config not found
SQL
0 vote290 views1 answer
Mariadb number format
SQL
0 vote279 views1 answer
An exception occurred while executing a transact-sql statement or batch user,group or role already
SQL
3 votes309 views5 answers
Foreign keys
SQL
0 vote297 views1 answer
Oserror mysql_config not found virtualenv
SQL
-1 vote317 views5 answers
Left join
SQL
3 votes289 views1 answer
How to uninstall microsoft sql server
SQL
0 vote274 views1 answer
Mysql find non alphanumeric characters
SQL
0 vote254 views0 answer
SQL