isnull test

0

Please login or register to vote for this query.

(click on this box to dismiss)

Network Engineering

Q&A for network engineers

CREATE table #yourtable
    ([Id] int, [Value] varchar(6))
;

INSERT INTO #yourtable
    ([Id], [Value])
VALUES
    (1, null),
    (2, '2.4'),
    (3, 'ZH1E4A'),
    (4, 'Fork'),
    (5, '857685')
;

SELECT ISNULL(Value, 'abc') FROM #yourtable;

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results