/SQL/Sql strip non alphanumeric characters

Sql strip non alphanumeric characters

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

Sql strip non alphanumeric characters

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 vote143 views1 answer
How to list function in psql
SQL
0 vote144 views1 answer
Mysql récupérer le code création de vue
SQL
0 vote137 views2 answers
Sql last updated
SQL
1 vote141 views1 answer
How to test for sql injection
SQL
0 vote150 views1 answer
How to connect sqlalchemy to mysql and deploy it
SQL
27 votes144 views5 answers
Add column in table
SQL
0 vote141 views1 answer
Get number of table colums in sql query
SQL
0 vote140 views1 answer
Como saber si tengo mysql instalado
SQL
1 vote136 views2 answers
DROP TABLes regardless of constraints
SQL
5 votes170 views3 answers
Db begintransaction laravel
SQL