|List:||General Discussion||« Previous MessageNext Message »|
|From:||John Halladay||Date:||February 15 2001 11:32pm|
|Subject:||If, then, else . . .|
|View as plain text|
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.
|• If, then, else . . .||John Halladay||16 Feb|
|• Re: If, then, else . . .||Thiru||16 Feb|
|• RE: If, then, else . . .||Quentin Bennett||16 Feb|