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 vote303 views1 answer
How to make a select in sql
SQL
1 vote315 views1 answer
Oracle apex version view
SQL
1 vote296 views2 answers
Populate sql table with random data
SQL
0 vote310 views1 answer
How to insert multiple rows in mysql using laravel
SQL
0 vote293 views1 answer
How to find database collation in postgres
SQL
57 votes531 views6 answers
Mysql alter table add column
SQL
0 vote292 views1 answer
Mysql delete from where like
SQL
1 vote294 views1 answer
Median mysql
SQL
0 vote297 views1 answer
Sqlalchemy query return only n results
SQL
2 votes324 views2 answers
Mysql add hours to time field
SQL