I should have added, too, that the data-type of the column value and the data-type of the value returned if it is null must be the same.
IOW, if it's an integer type, but a NULL value, asking it to return 'Ain't got none' will fail. ;-) From: [email protected] [mailto:[email protected]] On Behalf Of Wills, Steve Sent: May 22, 2014 3:30 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: convert Null values to zero in select statement 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]> [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.
