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 vote85 views1 answer
Mssql string length
SQL
0 vote138 views1 answer
TITLE: SQL Server principal "dbo" does not exist
SQL
0 vote143 views1 answer
Reset keys in sql
SQL
24 votes140 views5 answers
Import dump mysql
SQL
1 vote140 views1 answer
Error code 1292 mysql workbench
SQL
13 votes142 views2 answers
Sql join
SQL
0 vote132 views1 answer
Oracle last connection
SQL
0 vote132 views1 answer
MQL4 mql4 run ea on all symbols by adding to just one chart
SQL
0 vote180 views1 answer
Updating database in sql
SQL
1 vote131 views1 answer
Mysql random limit 1
SQL