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 vote265 views1 answer
Run mssql server terminal
SQL
0 vote269 views1 answer
Nosql vs sql
SQL
7 votes246 views1 answer
Grant schema permissions postgres
SQL
0 vote276 views2 answers
Sql query inner join 3 tables
SQL
0 vote260 views1 answer
Oracle sql generate list of days
SQL
0 vote265 views1 answer
How to select only id where is not in column mysql
SQL
0 vote267 views1 answer
Sql server query database space available
SQL
1 vote267 views1 answer
Load mysql dumb
SQL
0 vote270 views1 answer
Insert output identity
SQL
-2 votes276 views1 answer
No module named '_sqlite3
SQL