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

8 votes309 views1 answer
Alter tablespace add datafile
SQL
0 vote330 views1 answer
Parent: [Error: SQLITE_READONLY: attempt to write a readonly database] {
SQL
1 vote339 views1 answer
Find a column in all tables postgres
SQL
0 vote381 views1 answer
Sql check if field is not null
SQL
2 votes335 views3 answers
Sql interview query questions
SQL
0 vote361 views1 answer
Postrgesql concat 2 columns divided by ;
SQL
31 votes319 views1 answer
Postgresql add column with constraint
SQL
8 votes338 views3 answers
Connect python to mysql
SQL
0 vote333 views1 answer
How to search query in python3 sqlite3
SQL
3 votes308 views1 answer
How to check schema privileges in oracle
SQL