Dion,

D> What is the easiest way to return a 0 instead of a negative value (eg -78)
D> in an sql result set.

try
select case when x < 0 then 0 else x end
from sometable

Ciao
--
Nando Dessena
======================================================
I support Firebird, I am a Firebird Foundation member!
Join today at http://www.firebirdsql.org/ff/foundation
======================================================