SQL - Refinement - ISNULL ()

Question

I have the following logic in a stored procedure.

What's going on here?

If the color is null, replace it with ''

IF ISNULL(@color, '') <> '' 
BEGIN
END

+3

sql sql-server

Mark Apr 28 15 at 14:02

source to share

2 answers

When @color is NULL

replaced with ''

.

So when @color

is ( NOT NULL OR''

) will be executed BEGIN .. END

.

+2

Ralf de Kleine Apr 28 15 at 14:06

source to share

veljasije · Accepted Answer · 2015-04-28T14:05:36+0000

This is the same as:

IF (@color IS NOT NULL AND @color <> '') 
   THEN ...

One more thing, try using a COALESCE

function instead ISNULL

, because SQL Standard is suggested first. The syntax is very similar:

IF COALESCE(@color, '') <> '' 
BEGIN
    ...
END