/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

1 vote252 views2 answers
OSError: mysql_config not found mysql_config --version mariadb_config --version mysql_config --libs ---------------------------------------- ERROR: Command errored out with exit status 1: python setup.py egg_info Check the logs for full command outpu
SQL
0 vote288 views1 answer
Postgresql CREATE EXTENSION pgcrypto
SQL
0 vote316 views2 answers
Mysql update two tables at once
SQL
0 vote308 views3 answers
Classement rang mysql 7
SQL
26 votes290 views6 answers
Modify column name in sql
SQL
3 votes299 views1 answer
Async await mysql nodejs
SQL
0 vote316 views1 answer
Find the names of sailors who have reserved at least one boat
SQL
1 vote276 views1 answer
Sql select table header
SQL
6 votes278 views1 answer
SQL insert all columns
SQL
-1 vote285 views1 answer
How to check table exists or not in postgresql
SQL