Thread
:
help on a join query
View Single Post
#
10
(
permalink
)
08-20-09, 16:41
r937
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
r937
View Public Profile
Visit r937's homepage!
Find all posts by r937