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 vote167 views1 answer
Mysql installer no packages found
SQL
0 vote135 views1 answer
Sqldf change user
SQL
1 vote154 views1 answer
Sql row having max
SQL
0 vote199 views1 answer
Sql alchemy escape ; in insert statement
SQL
0 vote157 views1 answer
USING THE NOT CONDITION IN SQL
SQL
1 vote177 views1 answer
Is sql fast
SQL
1 vote167 views1 answer
Count of tables in database mysql
SQL
13 votes144 views2 answers
Get tables in database sql
SQL
0 vote150 views1 answer
Create user faunadb
SQL
1 vote142 views1 answer
Oracle user last connected
SQL