/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 vote159 views1 answer
Oracle transaction rollback not working
SQL
0 vote125 views3 answers
Postgresql allow remote connections
SQL
9 votes131 views6 answers
Check constraint in sql
SQL
1 vote75 views1 answer
Oracle boolean to varchar
SQL
3 votes134 views3 answers
Mysql get table size
SQL
3 votes125 views3 answers
Docker create postgresql database
SQL
0 vote112 views1 answer
Replace multiple string in query sql
SQL
1 vote71 views1 answer
Mssql string length
SQL
0 vote113 views1 answer
Postgres : ERROR: division by zero
SQL
0 vote130 views1 answer
Mysql root localhost run
SQL