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 vote107 views1 answer
Sql counter column
SQL
0 vote106 views1 answer
Sql xampp gabungan nama awal dan akhir
SQL
0 vote106 views1 answer
Sql mod even odd
SQL
10 votes122 views6 answers
Mysql set root password
SQL
1 vote119 views1 answer
Psql connect
SQL
1 vote119 views1 answer
T-SQL / AZURE Reseed
SQL
0 vote105 views1 answer
Sql on-premises
SQL
3 votes97 views1 answer
Sql select all
SQL
8 votes111 views1 answer
Show mysql user table
SQL
0 vote128 views1 answer
Replace sqlalchemy
SQL