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

1 vote193 views1 answer
Postgres convert exisiting column to text
SQL
0 vote142 views1 answer
FindAllBy
SQL
1 vote216 views1 answer
Mysql get latest duplicate rows
SQL
9 votes208 views2 answers
Sql limit order by
SQL
36 votes216 views3 answers
Add column in mysq
SQL
0 vote198 views1 answer
Get the previous column of a table in mysql
SQL
0 vote183 views1 answer
Mysql server not starting in xampp in mac
SQL
0 vote258 views1 answer
Sql count matching group by
SQL
0 vote213 views1 answer
Simple plsql program run in oracle sql developer but got the error
SQL
0 vote226 views1 answer
Mysql changer nom table
SQL