/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 vote146 views1 answer
Mysql count unique in group statement
SQL
0 vote142 views1 answer
How to select all fieldsin a soql query
SQL
0 vote162 views1 answer
Nodejs sql get one to many relationship as array
SQL
1 vote152 views1 answer
Mysql select from outside
SQL
17 votes138 views6 answers
Mysql import sql file
SQL
0 vote149 views1 answer
Oracle query to find schema you are working on
SQL
5 votes99 views1 answer
Mongodb vs
SQL
7 votes142 views1 answer
Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column. To disable safe mode, toggle the option in Preferences -> SQL Editor and reconnect.
SQL
24 votes168 views4 answers
Delete db postgres
SQL
0 vote217 views1 answer
Sql to search who modified
SQL