View Single Post
  #10 (permalink)  
Old 08-20-09, 16:41
r937 r937 is offline
SQL Consultant
 
Join Date: Apr 2002
Location: Toronto, Canada
Posts: 19,524
of what use would a single argument COALESCE be?

if foo is not NULL, then COALESCE(foo) will return foo

if foo is NULL, then COALESCE(foo) will return NULL

why would you use COALESCE(foo) when foo by itself gives the same result?
__________________
r937.com | rudy.ca
please visit Simply SQL and buy my book
Reply With Quote