/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

2 votes207 views1 answer
Brew start postgres manual
SQL
6 votes166 views2 answers
Mysql timestamp to date
SQL
1 vote149 views1 answer
Import database from a file using mysql commandline
SQL
0 vote187 views1 answer
SQL Server INSERT INTO SELECT By Complete Examples - NAYCode.com
SQL
0 vote160 views1 answer
Make parameters nullable in sql server
SQL
2 votes228 views1 answer
Tsql copy table
SQL
0 vote150 views1 answer
Php delete database
SQL
0 vote140 views1 answer
FIND AVERAGE SALARY EARNER IN SQL
SQL
4 votes168 views1 answer
Describe table mysql
SQL
3 votes245 views2 answers
Savepoint in sql
SQL