CASE Statement
From: Mtek <mtek_at_mtekusa.com>
Date: Tue, 24 Jun 2008 07:14:46 -0700 (PDT)
Message-ID: <07990ff8-18ea-44d1-b553-5176a7ec42e7@59g2000hsb.googlegroups.com>
Date: Tue, 24 Jun 2008 07:14:46 -0700 (PDT)
Message-ID: <07990ff8-18ea-44d1-b553-5176a7ec42e7@59g2000hsb.googlegroups.com>
Hi,
I know I can probably do this in an IF statement(s). But, I was wondering if you can have a query with a CASE in it, and later in the query refer to a value eariler in the query.
My guess is no, but if I case column 1, and column 2 is based on the value derived from the case of column 1, and so on, is that easily done?
If not, it is onto putting it in the code......
Thanks!
John Received on Tue Jun 24 2008 - 09:14:46 CDT