/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 vote134 views1 answer
Running percentage of total postgres
SQL
0 vote125 views1 answer
Sqlalchemy get ids
SQL
0 vote115 views1 answer
Coalesce for comma separated in sql server
SQL
0 vote125 views1 answer
Mysql sum with group by
SQL
0 vote132 views1 answer
Alter fedora mysql 8.0 user
SQL
62 votes154 views8 answers
Mysql add column
SQL
0 vote119 views1 answer
Returning with sqlalchemy
SQL
18 votes116 views3 answers
Find column name in database
SQL
0 vote121 views1 answer
Postgres - Login and connect as default user
SQL
7 votes112 views3 answers
Sql update where id
SQL