/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 vote273 views1 answer
How to lock table in mysql
SQL
0 vote285 views1 answer
Mysqldump: error:
SQL
0 vote251 views1 answer
Sql value exists in column
SQL
0 vote253 views1 answer
Substract variable amount of minutes from timestamp postgresql
SQL
0 vote268 views1 answer
Postgresql on conflict pair
SQL
34 votes257 views6 answers
Install mysql client ubuntu
SQL
2 votes256 views1 answer
Laravel sql String
SQL
1 vote274 views1 answer
What is a Database?
SQL
1 vote270 views1 answer
Illuminate\Database\QueryException SQLSTATE[HY000] [2002] Connection refused (SQL: select * from information_schema.tables where table_schema = laravel and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote275 views1 answer
Write SQL in ruby on rails
SQL