/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 vote351 views1 answer
Import sql inside hide sql
SQL
0 vote328 views1 answer
Sql how to display two atributes as one in sql
SQL
0 vote363 views1 answer
Sqlite woth cmake
SQL
4 votes379 views3 answers
Sql find second highest salary employee
SQL
0 vote351 views2 answers
Enter into postgresql database,create user and grant Access
SQL
0 vote382 views1 answer
Postgresql custom order by
SQL
1 vote318 views3 answers
String to int mysql
SQL
1 vote312 views1 answer
Sql update table remove spaces
SQL
0 vote400 views1 answer
Remove mysql from centos 7
SQL
10 votes353 views2 answers
Rtrim sql
SQL