|
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
Navigation:
[Reply to this message]
|