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

4 votes248 views1 answer
Postgresql list sequences
SQL
-1 vote231 views1 answer
Partial search in sql
SQL
23 votes179 views6 answers
ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
0 vote184 views1 answer
How to take sum of column with same id in "JPQL?"
SQL
0 vote246 views1 answer
Cannot start database server xampp mac os
SQL
0 vote196 views1 answer
Mysql get nth highest
SQL
0 vote199 views1 answer
T-SQL Never ending DELETE
SQL
0 vote240 views2 answers
Query the list of CITY names from STATION that either do not start with vowels or do not end with vowels. Your result cannot contain duplicates.
SQL
0 vote187 views1 answer
Oracle table free space
SQL
0 vote222 views1 answer
Creating sqeuence in oracle database
SQL