question about case statement

hello,

i'd like to combine to clauses of my case statement, and I do this:

case check when value1    //do something when value2    //do something (the same as in the first when) end

But how can I combine the two "when"-s. It is redundant to write the same code to "do something"

I tried to find the syntax, but couldn't. I tried something like:

case check when value1 when value2    //do the thing end

but this only works when check = value2

Thanks!

hello,

i'd like to combine to clauses of my case statement, and I do this:

case check when value1    //do something when value2    //do something (the same as in the first when) end

But how can I combine the two "when"-s. It is redundant to write the same code to "do something"

[...]

case check when value1, value2    //do something end

Thanks!

--Greg

Thanks, Greg!