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 vote139 views1 answer
How to order result of subquery in select
SQL
0 vote139 views1 answer
Get foreign table names mysql
SQL
0 vote177 views1 answer
Client does not support authentication protocol requested by server sqlyog
SQL
0 vote161 views1 answer
Sql_inner_join
SQL
2 votes145 views1 answer
Postgresql create table as select
SQL
0 vote112 views1 answer
Postgres create database if not exists
SQL
0 vote145 views1 answer
Ajax error exception handeling
SQL
1 vote153 views1 answer
Postgres format date in select
SQL
2 votes160 views1 answer
Postgresql resolv duplicate value violates unique constraint
SQL
2 votes179 views2 answers
How to check data type in sql server
SQL