/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 vote221 views1 answer
SQLServerException.makeFromDatabaseError
SQL
0 vote255 views1 answer
Mysl like insert a variable
SQL
3 votes188 views1 answer
Mysql set field unique
SQL
8 votes225 views1 answer
Mysql limit rows
SQL
7 votes217 views6 answers
Mysql group concat
SQL
1 vote210 views1 answer
How to fetch alternate records from two tables
SQL
0 vote186 views2 answers
What is 1=2 in sql
SQL
5 votes185 views2 answers
Update all rows mysql
SQL
0 vote204 views1 answer
Convert uniqueidentifier to varchar in sql
SQL
33 votes210 views6 answers
Sql delete
SQL