/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 votes134 views1 answer
Sql select in list
SQL
12 votes205 views4 answers
Psql command not found
SQL
-1 vote224 views1 answer
Mysql faster insert
SQL
0 vote184 views1 answer
Like sql for second letter of the family name
SQL
12 votes195 views1 answer
Docker mysql random root password
SQL
-1 vote215 views4 answers
Restart mysql server ubuntu
SQL
1 vote210 views2 answers
Find nth highest salary of an employee
SQL
1 vote192 views1 answer
Return size of tables in mysql
SQL
0 vote179 views1 answer
Importerror no module named mysql.connector raspberry pi
SQL
2 votes190 views1 answer
Mysql ALTER TABLE ADD COLUMN BOOLEAN AFTER DEFAULT "1";
SQL