At 11:11 PM 9/25/2005, Steve Vellella wrote:
.. it only calculates the max paydate if all 6 paydate columns have data
in them. Is this what I should expect or is this not functioning properly.
Steve,
First, you need to check the EQNULL settings of your database.
SHOW EQNULL
or
SET VAR vCheckEQNULL = (CVAL('EQNULL'))
SHOW VAR vCheckEQNULL
FYI, the function LMAX is not the same as the function MAX, which is used
only with the SELECT command.
LMAX function returns the MAXIMUM value in LIST.
Example:
SET VAR vLMax = (LMAX(2,10,99,88,75,3,16))
Variable vLMax will return the value of 99, the highest number in the LIST.
Very Best R:egards,
Razzak.
