/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

0 vote230 views2 answers
How to truncate all table in mysql workbench
SQL
0 vote211 views1 answer
Calculer pourcentage mysql
SQL
0 vote184 views1 answer
Mysql update from n to 100
SQL
51 votes584 views6 answers
Installing mysql on ubuntu
SQL
2 votes183 views1 answer
Drop all database tables oracle sql developer
SQL
5 votes260 views4 answers
Restart the psql server windows
SQL
18 votes178 views4 answers
Foreign key mySql
SQL
1 vote233 views1 answer
Oracle grant select on schema
SQL
4 votes181 views1 answer
Wildcard in sql
SQL
10 votes176 views2 answers
Tsql merge example
SQL