COALESCE OR CASE?

Database
Enthusiast

COALESCE OR CASE?

WHICH ONE IS BETTER TO USE COALESCE OR CASE TO PASS SPACES OR ANY VALUE FOR NULL
2 REPLIES
Enthusiast

Re: COALESCE OR CASE?

Actually it doesn't matter because COALESCE is implemented as CASE expression, it's just a nice shorthand to have for simple situations like the one you mentioned.
Enthusiast

Re: COALESCE OR CASE?

Thanx