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

20 votes221 views4 answers
Sql count if
SQL
0 vote211 views1 answer
Postgresql combine values in one field
SQL
1 vote225 views1 answer
Sql server delete top 1000
SQL
0 vote202 views1 answer
Mysql min value row
SQL
0 vote197 views2 answers
How to list all values of a column that start with a letter in sql
SQL
1 vote201 views2 answers
Login to mysql
SQL
23 votes190 views4 answers
Sql server substring
SQL
0 vote170 views1 answer
Sql min
SQL
1 vote207 views1 answer
Postgresql define pk sequence next number
SQL
0 vote205 views1 answer
Oracle sql log to console
SQL