Hi all,

I'd like to add multiple fields in a db query. That is not a problem, like:

select s1+s2+s3 as TotalAmount

However, when one of the field values is null, then the result is zero. How
can I get this to work?

TIA,

John

_______________________________________________
Delphi mailing list
[EMAIL PROTECTED]
http://ns3.123.co.nz/mailman/listinfo/delphi

Reply via email to