Re: Divide By Zero Error

Posted in 1995

Jack Parker — 15 Aug 1995 08:03:03 -0400 — source: Informix-list mailing list archive (1991-1998)

> > union two selects: > > SELECT stuff> ...... col1/col2 > WHERE ..... > AND col2 != 0 > > UNION > > SELECT stuff> ...... 0 > WHERE ..... > AND col2 != 0 ^^^ typo: should read col2 = 0 cheers j. _____________________________________________________________________________ Jack Parker - Hewlett Packard, BSMC Boise, Idaho, USA jparker@hpbs3645.boi.hp.com _____________________________________________________________________________ Discover America, get lost on a rally. _____________________________________________________________________________ Any opinions expressed herein are my own and not those of my employers. _____________________________________________________________________________