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 vote137 views1 answer
Postgresql concat string with separator
SQL
0 vote150 views1 answer
Mysql failed to login as root@localhost
SQL
0 vote109 views1 answer
Phpmyadmin tabellentyp ändern
SQL
1 vote100 views1 answer
Rows to comma separated values in mssql
SQL
0 vote117 views1 answer
Get last date join sql
SQL
0 vote146 views1 answer
How to check rollback status in oracle
SQL
0 vote122 views1 answer
Count database access django
SQL
0 vote177 views1 answer
Mysql update all record removing 2 hours from column
SQL
4 votes116 views3 answers
Sql drop primary key
SQL
3 votes139 views1 answer
How to add unique constraint in mysql table
SQL