Dennis, try something like this: SELECT my_Value, (IFNULL( my_Value, 'my_Value_IS_NULL', my_Value)) FROM ... WHERE ...
From: [email protected] [mailto:[email protected]] On Behalf Of Hodges, Dennis Sent: May 22, 2014 3:25 PM To: RBASE-L Mailing List 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]<mailto:[email protected]> Please note: e-mail may be subject to public disclosure.
