/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

3 votes136 views1 answer
Show index table
SQL
0 vote129 views1 answer
Resulting Query
SQL
25 votes150 views6 answers
Import database mysql command line
SQL
-1 vote157 views1 answer
Mysql coalesce
SQL
0 vote146 views1 answer
Oracle sql drop table
SQL
3 votes234 views1 answer
Ssh check mysql version
SQL
0 vote148 views1 answer
Is not sql
SQL
0 vote147 views1 answer
Insufficient privileges while creating view in sql oracle
SQL
0 vote141 views1 answer
Import sql in postgresql
SQL
1 vote137 views1 answer
Generate random data postgresql
SQL