If, then, else . . .

[John Halladay]

If I am querying a field that has either "a" or "b" as a value and I want a
second field's value to be dependant on the first field's value, how would I
right that?

SELECT field1, IF(field1="a",100,IF(field1="b",200,"ERROR") FROM table;

The IF,THEN,ELSE is the only thing I can think of, but that is the Excel,
Access side of my brain talking.  Sorry for the basis question.  Any help
would be much appreciated.

Thanks.

John H.