Let's say I have a table t1 with two fields, x and y. How do I write an
sql statement like:
select x if y>1 else 0 from t1;
For every record in which y is > 1, you get x back. Otherwise, you get 0
returned.
Thanks,
----------------------------------------------------------------
Travis Bauer | CS Grad Student | IU |www.cs.indiana.edu/~trbauer
----------------------------------------------------------------