Posted by yoohanman on 09/13/05 16:33

Hi,

I have a select statment that correctly returns zero rows at times. I
would like to be able to return the value 0 (a single row with the
value 0) whenever the logic returns zero rows.

something like this

If no.of.rows.returned = 0 then
output 0
else
output query results
end if

Can anyone poing me in the right direction to do this?

many thanks,
yohan

[Back to original message]