/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 vote103 views1 answer
Uncaught Error: Call to undefined function DatabaseOld\mysqli_connect()
SQL
0 vote125 views1 answer
Show all sequences postgres
SQL
0 vote100 views1 answer
Authentication in sql server
SQL
23 votes102 views4 answers
Uninstall postgresql ubuntu
SQL
12 votes102 views2 answers
Select into insert sql server
SQL
3 votes113 views2 answers
Install mysql powershell
SQL
0 vote103 views1 answer
Mysql select where field like in list
SQL
13 votes152 views3 answers
Mysqldump structure only
SQL
0 vote106 views1 answer
MySQL INSERT IGNORE Statement
SQL
6 votes100 views2 answers
Mysql concatenate two columns into one
SQL