Re: Constructing column from different individual fields in same row.

On Tue, Sep 09, 2003 at 21:02:21 -0700,
  Alex Martinoff <froggle2003@yahoo.com> wrote:
> I'm wondering if it's possible to have a query construct a column
> where the value of the column at each row is taken from another field
> in that same row. For example, suppose you have a table like:

You can use CASE to do this.