I have a view with production data that includes 3 columns for hours and I want to create a total hours column. I previously converted null values on all three columns using ifnull(realhrs,0,realhrs). The following gives me zeros for tothrs:
Select *, (realhrs + safhrs + callhrs) as tothrs from t3append Any help would be greatly appreciated. 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.
