/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 vote208 views1 answer
Space not removing from column in sql
SQL
0 vote203 views2 answers
How to update date in oracle
SQL
6 votes230 views1 answer
How to get the size of the database in postgresql
SQL
0 vote209 views1 answer
Sql server synonym
SQL
0 vote201 views1 answer
Sql server union if table exist
SQL
0 vote192 views1 answer
Install package for sqlserver in asp.net core
SQL
16 votes199 views6 answers
Insert sql
SQL
1 vote209 views1 answer
Mysql add fields
SQL
0 vote215 views1 answer
(PDOException(code: 2002): SQLSTATE[HY000] [2002] Permission denied at
SQL
0 vote210 views1 answer
View to table sql
SQL