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

0 vote100 views1 answer
Postgresql create user roles
SQL
1 vote99 views1 answer
Oracle rolling back transactions
SQL
4 votes97 views1 answer
Mysql set max connections
SQL
17 votes231 views4 answers
Show all tables in oracle
SQL
0 vote104 views1 answer
How to read the potentail error messages in ssis package
SQL
15 votes101 views7 answers
MYSQL
SQL
0 vote107 views1 answer
Get first 3 letter of department name in sql
SQL
1 vote127 views4 answers
How to check table in postgresql from terminal
SQL
0 vote105 views1 answer
Oracle sql procedure return value
SQL
-1 vote118 views1 answer
SQL query to convert DD/MM/YYYY to YYYY-MM-DD
SQL