/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 vote141 views1 answer
Mariadb list tables
SQL
0 vote176 views1 answer
Can sqldatareader be null
SQL
1 vote173 views1 answer
Sql find column name like
SQL
0 vote200 views1 answer
Install mysql on bash
SQL
13 votes188 views3 answers
Change data type postgresql
SQL
0 vote202 views2 answers
Impala rename column name
SQL
5 votes178 views3 answers
Postgres show databases
SQL
0 vote240 views1 answer
Play framework connection via windows sql server
SQL
0 vote178 views1 answer
Oracle last connexion
SQL
0 vote180 views2 answers
Disadvantages of stored procedures sql
SQL