Returned two values from a case statement?

[Brent Bigler]

I'm trying to write a select statement that looks something like this:

select * from table where tablefield in (0, 8)

The "0, 8" needs to be generated within the SQL by reference to another field in the table. I had hoped something like this would work:

select * from table where tablefield in (case otherfield when 1 then (0, 8) else 3)

... but -- of course -- it fails.

Does anyone have any suggestions on how to derive this value?

Thanks for any help.

-- Brent