I have a NVARCHAR column that I want to apply multiple replacements commands to. The words that have to be replaced (actually they are deleted by replacing them with an empty string) are listed in a TableA. I found this thread, that shows how to do this with a @parameter:
DECLARE @String varchar(max) = 'Hexagonal 28 mm'
SELECT @String = replace(@String, CriticalWord, '') from TableA
SELECT @String
I'm new to this kind of syntax and wonder how to apply that logic to a column of a TableB:
Select StringColumn from TableB
What I'm trying to do is to isolate the numeric part; as there is a limited amount of words (hexagonal, mm,..) that appear in that string and that need to deleted I came up with that idea.