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 vote374 views1 answer
Is not numeric sql
SQL
0 vote332 views1 answer
Mysql money value
SQL
1 vote373 views1 answer
Liquibase alter column type / length
SQL
0 vote335 views1 answer
Price-colour
SQL
0 vote363 views1 answer
Geopoint from json mysql function
SQL
0 vote362 views1 answer
Oracle service name view
SQL
1 vote367 views1 answer
Drop table if exists oracle
SQL
-1 vote306 views10 answers
Delete Query in SQL Server
SQL
2 votes378 views1 answer
Postgresql create table as select
SQL
4 votes402 views2 answers
Postgresql float data type
SQL