Haven't tested this, but I think:
select (IFNULL(amount,0,amount)) from table
Karen
-----Original Message-----
From: Hodges, Dennis <[email protected]>
To: RBASE-L Mailing List <[email protected]>
Sent: Thu, May 22, 2014 3:26 pm
Subject: [RBASE-L] - convert Null values to zero in select statement
How can I convert null values to zeroes in a select statement?
Dennis Hodges
Maintenance Management Manager
FDOT Office of Maintenance MS #52
PH: (850) 410-5635
FAX: (850) 410-5511
[email protected]
Please note: e-mail may be subject to public disclosure.
