/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

2 votes141 views2 answers
Select multiple tables mysql
SQL
0 vote172 views1 answer
Drop table BigQuery table columns
SQL
0 vote151 views1 answer
Mysqli_real_connect(): (28000/1045): Access denied for user 'u0738423'@'www8.aname.net' (using password: YES)
SQL
4 votes147 views1 answer
Change nls_date_format
SQL
10 votes148 views2 answers
Mysql alter add foreign key
SQL
0 vote116 views1 answer
Mysql offset from bottom
SQL
7 votes159 views2 answers
N highest salary in sql
SQL
7 votes163 views2 answers
How to create index mysql
SQL
0 vote152 views1 answer
Increase speed of like queries postgres
SQL
0 vote158 views1 answer
Postgresql replace html tags from string
SQL