Question : t-sql remove all non-alphanumeric characters from a string
Answered by : jittery-jellyfish-wrk2f7nu15rk
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 : https://stackoverflow.com/questions/1007697/how-to-strip-all-non-alphabetic-characters-from-string-in-sql-server | Last Update : Mon, 23 Mar 20
Question : sql strip non alphanumeric characters
Answered by : marc-heidemann
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 : https://stackoverflow.com/questions/26505966/get-character-only-string-from-another-string-in-sql-server | Last Update : Thu, 12 Nov 20