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 vote114 views4 answers
Fatal database postgres does not exist
SQL
1 vote121 views1 answer
Import mysql dump database command line linux
SQL
1 vote125 views1 answer
Sqlalchemy order by descending
SQL
0 vote116 views1 answer
How to put is null in where in clause
SQL
0 vote126 views1 answer
Desinstaller mysql sur ubuntu definitivement
SQL
-1 vote116 views1 answer
How to check table exists or not in postgresql
SQL
1 vote118 views1 answer
Search for tables with name postgresql
SQL
0 vote117 views1 answer
Power bi union columns
SQL
0 vote127 views1 answer
Select multiple row from primary key sql
SQL
11 votes124 views4 answers
Update row in mysql
SQL