/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 vote277 views1 answer
C# add a textbox in mysql select
SQL
3 votes260 views1 answer
Oracle undo tablespace list by user
SQL
3 votes274 views1 answer
Créer une table sql
SQL
1 vote263 views1 answer
Search for tables with name postgresql
SQL
0 vote271 views1 answer
Create mysql pool connection python flask
SQL
2 votes275 views3 answers
Oracle show column of table
SQL
4 votes269 views2 answers
Could not find driver (SQL: select * from information_schema.tables where table_schema = pics and table_name = migrations and table_type = 'BASE TABLE')
SQL
8 votes279 views1 answer
Script to add datafile to tablespace
SQL
1 vote262 views1 answer
Get url of cpanel database hostname
SQL
0 vote352 views1 answer
Current month transactions in mysql
SQL