Re: Conditional statements in SQL

Posted in 2000

Obnoxio The Clown — Thu, 24 Feb 2000 10:55:39 GMT — source: Informix-list mailing list archive (1991-1998)

From: "Graeme Muirhead" <csi@muirhead.freeuk.com> > >Is it possible to have conditional statements in an SQL query? For example, >if the value in column A is "C" multiply the value in column B by 1, if the >value of column A is "R" muliply the value in column B by -1, then sum the >values in column B. You mean like with the CASE statement? No. :-) ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com