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

0 vote318 views1 answer
Execute a stored procedure in another stored procedure in SQL server
SQL
2 votes326 views1 answer
Add default sql server
SQL
0 vote360 views1 answer
Select year from dual oracle
SQL
0 vote323 views1 answer
Mysql cdn link
SQL
0 vote301 views1 answer
Oracle sql date summer time
SQL
0 vote322 views1 answer
Plpgsql coalesce equivalent for empty string
SQL
-1 vote335 views1 answer
Condition in orderby mysql
SQL
0 vote357 views1 answer
Plsql check how much space all databases are consuming
SQL
0 vote351 views1 answer
SQL-Arten
SQL
3 votes348 views2 answers
SqlMessage: "Host '192.168.64.1' is not allowed to connect to this MariaDB server
SQL