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 vote366 views1 answer
Database Queries
SQL
0 vote383 views1 answer
Check constraint is violated
SQL
1 vote379 views1 answer
Postgres left join
SQL
3 votes313 views1 answer
V$session not found in oracle
SQL
1 vote355 views1 answer
Increasing font and zooming in mysql workbench
SQL
0 vote380 views1 answer
Best practive to pass multiple table to stored procedure in sql server
SQL
23 votes353 views4 answers
Uninstall postgresql ubuntu
SQL
1 vote343 views2 answers
Sql for date greater than
SQL
0 vote325 views1 answer
Mysql trim characters
SQL
6 votes361 views4 answers
Mysql update set
SQL