Divide By Zero Error

Posted in 1995

Harvey Keown — 10 Aug 1995 13:59:26 GMT — source: Informix-list mailing list archive (1991-1998)

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