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 vote218 views2 answers
How to check username in mysql command line
SQL
0 vote222 views1 answer
Oracle sql winter time change
SQL
0 vote235 views1 answer
Populate db from command line postgres
SQL
0 vote228 views1 answer
Ran rails db:migrate and got == 20210620104415 DeviseCreateUsers: migrating ================================ -- create_table(:users) rails aborted! StandardError: An error has occurred, this and all later migrations canceled: SQLite3::SQLE
SQL
3 votes222 views3 answers
How to add month in update sql
SQL
2 votes232 views2 answers
Sql query to list all tables in a database sql server
SQL
0 vote225 views1 answer
View psql output in horizontal scrolling
SQL
2 votes257 views1 answer
Oracle Column Names of a table
SQL
0 vote245 views1 answer
Create table split string function in sql server
SQL
14 votes240 views3 answers
Alter foreign key
SQL