Dennis
If you want to leave the values as null then your select statement would be SELECT something .... FROM tableName WHERE columnName IS NULL OR columnName = 0 If you want to change the null values to 0 in the table then UPDATE tableName SET ColumnName = 0 WHERE ColumnName IS NULL Important once you update column to 0 you won't be able to undo it. IF this is what you are trying to do then SET VAR v1 INTEGER = 0 SELECT columname INTO v1 INDIC iv1 FROM TableName WHERE ........... IF v1 IS NULL THEN SET VAR v1 = 0 ENDIF Buddy From: [email protected] [mailto:[email protected]] On Behalf Of Hodges, Dennis Sent: Thursday, May 22, 2014 4: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 <mailto:[email protected]> [email protected] Please note: e-mail may be subject to public disclosure.
