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

2 votes166 views1 answer
Node and mysql like
SQL
0 vote169 views1 answer
Mysql update privileges
SQL
4 votes201 views1 answer
Oracle nls_date_format
SQL
0 vote150 views1 answer
Mariadb list tables
SQL
5 votes177 views1 answer
Ascending order and where in sql
SQL
45 votes204 views5 answers
Grant all privileges mysql
SQL
0 vote181 views1 answer
FIND ABOVE AVERAGE SALARY EARNER IN SQL
SQL
0 vote172 views4 answers
Rownum in sql
SQL
0 vote192 views1 answer
Mariadb disable foreign key checks
SQL
0 vote192 views2 answers
Disadvantages of stored procedures sql
SQL