Re: Divide By Zero Error

}>>>>>>>>> Perry's response to Harvey Keown <<<<<<<<<< Yep, include "where denominator_column != 0" in the where clause. } From: Harvey Keown <ddsihck@sunny.oed.db.za> } Subject: Divide By Zero Error } Date: 10 Aug 1995 13:59:26 GMT } To: informix-list@rmy.emory.edu } } Hi All } } Does anyone know how to prevent a 'Divide By Zero Error' when } executing a SELECT. I'm dividing 2 columns in a computed field. } There are occasions when the divisor WILL be zero. When this } condition occurs, instead of the 'Divide By Zero Error' } occuring I want the result to be zero. I don't want to filter } the column containing zeros. } } Thxs Harvey Keown } } } -perryd (Guru) ==================================================================== = Perry Dillard - CASE Tools Development Team Leader = = FourGen Software, Inc. = = FourGen Building = = 115 NE 100th Street = = Seattle, W.A. 98125-8098 = = = = e-mail: perryd@fourgen.com = ====================================================================