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

12 votes288 views4 answers
Mysql ifnull
SQL
0 vote296 views1 answer
How to check event scheduler status mysql
SQL
0 vote296 views1 answer
Count database access django
SQL
12 votes283 views1 answer
Docker mysql random root password
SQL
29 votes286 views5 answers
Mysql show table structure
SQL
0 vote282 views1 answer
Show create table in postgresql
SQL
2 votes301 views1 answer
Db.relationship sqlalchemy flask
SQL
1 vote283 views1 answer
Select inside insert query
SQL
0 vote341 views1 answer
Insert into using contant values and source table columns with sql
SQL
0 vote283 views1 answer
Désinstaller postgresql linux
SQL