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

15 votes295 views2 answers
Sql order by alphabetical
SQL
0 vote146 views1 answer
Table values functions in SQL
SQL
0 vote310 views1 answer
What URL will take me directly to Rudolph's Reddit comment history?
SQL
7 votes170 views2 answers
Mysql Public Key Retrieval is not allowed
SQL
0 vote163 views2 answers
Collation in sql
SQL
0 vote167 views1 answer
Second Step in installing SQL workbench
SQL
0 vote154 views2 answers
Sql searching via key word
SQL
1 vote139 views1 answer
Get count by weekly pivot table sql server
SQL
0 vote148 views1 answer
Database traccar
SQL
0 vote133 views1 answer
Trim sql oracle
SQL