shamimaziz

 Profile Answers by shamimaziz 

• Jul 21st, 2007

 

Coalesce is also available in Sybase
This functions evaluates the listed expressions and returns the first non-null value. If all the expressions are null, coalesce returns null

USAGE: coalesce(expression, expression [, expression]...)

EXAMPLE: coalesce(initialqty,finalqty,middleqty)

Returns the first occurrence of a non-NULL value in either the initialqty or finalqty or middleqty

Enjoy

supari

 Profile Answers by supari Questions by supari

• Mar 19th, 2008

 

shami,
Can u elaborate more, in terms of 2 tables A and B if we do a right outer join, how can we use coalesce