/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

5 votes202 views3 answers
Oracle first day of last year
SQL
0 vote198 views1 answer
Tsql generate rows
SQL
1 vote220 views1 answer
How to see which columns are indexxed mysql
SQL
0 vote243 views1 answer
Pgadmin postgres ERROR: database is being accessed by other users
SQL
0 vote206 views1 answer
Mysql procedure between two tables
SQL
6 votes330 views1 answer
Check Table Exists
SQL
0 vote221 views1 answer
Drop index in sql
SQL
0 vote196 views1 answer
What are the aggregate function in sql
SQL
0 vote245 views1 answer
Drush run sql select
SQL
3 votes208 views1 answer
How to check schema privileges in oracle
SQL