select [dbo].[RemoveSpecialCharacters]('125℃') select [dbo].[RemoveSpecialCharacters]('125°C')
ALTER Function [dbo].[RemoveSpecialCharacters](@Input VarChar(1000)) Returns VarChar(1000) AS Begin Declare @KeepValues as varchar(50) Set @KeepValues = '%[^a-zA-Z0-9 ]%' While PatIndex(@KeepValues, @Input) > 0 Set @Input = Stuff(@Input, PatIndex(@KeepValues, @Input), 1, '') Return @Input End
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)