If clause in SELECT statements

Is there any way to evaluate a field in a SELECT query w/o writting a User Function? This is an example of the logic that I would like to have in a view:

    select if([state]='NY','New York',[state]) as state_desc from state_tab

If the state column is NY then it would output New York, otherwise, it would return the value from the field.

Any Ideas,
Tim Gifford
tgifford(at)horizonstech.com Received on Tue Jul 18 2000 - 00:00:00 CDT