Delete the word null from text string

Question

I have a string that is like this word1 - null - word3, is it possible to write an sql query to remove the word null from the string of text?

Thanks

Answer 1

you can use REPLACE function:

DECLARE @Test AS VARCHAR(32)
SELECT @Test = 'word1 - null - word3'

SELECT REPLACE(@Test, 'null - ', '')

Answer 2

Use REPLACE.

Query

declare @str as varchar(50);
set @str = 'word1 - null - word3';

select replace(@str,'null','');