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

21 votes306 views7 answers
Table drop if exist sql server
SQL
1 vote347 views2 answers
Mysql error 1215
SQL
4 votes357 views3 answers
How to describe a table in sqlite3
SQL
0 vote396 views1 answer
Postgres list tables and row counts
SQL
1 vote341 views2 answers
DROP TABLes regardless of constraints
SQL
-1 vote345 views2 answers
On update cascade
SQL
12 votes348 views1 answer
Script to add new column in table sql
SQL
0 vote335 views1 answer
SHOW RESULT WITHOUT ROUND IN SQL
SQL
0 vote365 views2 answers
Uncaught Error: Cannot use object of type mysqli_result as array
SQL
0 vote359 views1 answer
Get rows from 1 table with other table empty mysql
SQL