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

9 votes183 views5 answers
Laravel to sql
SQL
0 vote169 views1 answer
Group by join columns per table
SQL
1 vote215 views1 answer
Sqlalchemy on delete set null
SQL
1 vote161 views1 answer
How to update date add hours in postgresql
SQL
1 vote196 views3 answers
Sql procedure
SQL
0 vote176 views1 answer
How to create a new shema using query languaage
SQL
0 vote161 views1 answer
Execut sql python
SQL
0 vote154 views1 answer
Automate mysql cli query
SQL
0 vote178 views1 answer
Mysql insert multiple rows based on select
SQL
0 vote195 views1 answer
Concat column value of same user in mysql
SQL