<<
select lsavg,(IFEQ(LSAVG, .VZERO, .VNULL, LSAVG)) from
color_line_study where lsavg = 0
lsavg
(IFEQ(LSAVG,.VZ
--------------- ---------------
0.
0.
0.
0.
0.
0.
0.
0.
0.
0.
>>You have ZERO set ON (SET ZERO ON). Therefore, the expression .vNull converts to 0. Try replacing with the literal value NULL in the IFEQ expression, although R:Base sometimes has datayping problems if you do that. Alternatively, you'll need return a special flag value (hopefully, LSAvg can never go negative?). -- Larry
