/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 vote295 views1 answer
FIND AVERAGE SALARY EARNER IN SQL
SQL
40 votes400 views4 answers
PostgreSQL add column
SQL
0 vote316 views1 answer
Mysql exception output
SQL
7 votes311 views2 answers
Execute mysql file
SQL
1 vote292 views1 answer
Give a column name to values generated from case statement in sql
SQL
0 vote307 views4 answers
Mysql on kubernetes
SQL
-1 vote301 views1 answer
Ssql to lowercqse
SQL
0 vote342 views1 answer
Sql server synonym
SQL
6 votes344 views2 answers
Mysql convert timestamp to date
SQL
2 votes330 views1 answer
Merge firstname and lastname in sql oracle
SQL