ISNULL function

Question

ISNULL function

yrstruly

Hall of Fame

Points: 3477
More actions
July 29, 2022 at 7:24 am

#4069835

I have found an explanation of the "ISNULL" on here: https://www.w3schools.com/sql/sql_ref_sqlserver.asp
What will be a good reason to use this function and spesificaly for views?

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Thom A SSC Guru Points: 99142 More actions · Answer 1

Why not refer to documentation for what is does? As for what is a good reason to use it in a VIEW, I'm not sure what you really mean. The reason to use the function is the return the second parameter when the first is NULL. The "good" reason to use it in a VIEW is when you need that behaviour. (Though never use it on a column in your WHERE or ON, use explicit OR logic there.)

Thom~

Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk

ZZartin SSC-Dedicated Points: 30921 More actions · Answer 2

yrstruly wrote:

What will be a good reason to use this function and spesificaly for views?

Because a field has nulls in it.

ISNULL function

Cookies on SQLServerCentral