/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 vote341 views1 answer
Mysql grant access to one database
SQL
0 vote337 views1 answer
Procedures sql insert mysql
SQL
3 votes392 views1 answer
Postgres count distinct
SQL
1 vote352 views1 answer
Data type and their numeric form
SQL
6 votes347 views4 answers
How to remove unique key in mysql
SQL
0 vote338 views1 answer
Optimize sql query
SQL
0 vote376 views1 answer
Soql update query
SQL
1 vote441 views1 answer
Sql and
SQL
0 vote328 views1 answer
Mysql error codeigniter
SQL
0 vote367 views1 answer
Pgsql is not permitted to log in
SQL