/SQL/T-sql remove all non-alphanumeric characters from a string

T-sql remove all non-alphanumeric characters from a string

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 vote263 views3 answers
Date_add mysql
SQL
0 vote174 views1 answer
Sql random decimal
SQL
0 vote214 views1 answer
Calculer pourcentage mysql
SQL
0 vote187 views1 answer
Mysql master slave setup with keepalived
SQL
0 vote183 views1 answer
Mysql repair a table
SQL
0 vote188 views2 answers
Sql join on comma separated field
SQL
0 vote199 views1 answer
Full outer join in mariadb mysql
SQL
2 votes176 views1 answer
Sql to char function with date
SQL
0 vote193 views1 answer
Linked server delete openquery
SQL
0 vote186 views1 answer
How to import sqlite driver class in java using maven
SQL