Shai Rosenfeld wrote:

> case number
> when 1: var = 'one'
> when 2: var = 'two'
> when 3: var = 'three'
> else
>         var = 'else'
> end
>
>
> but instead of assigning the 'var' variable for each 'when', what is the
> way to write the case statement, so i can assign 'var' at the end?

var=case number
...
end


HTH,
Sebastian
-- 
NP: Porcupine Tree - Start Of Something Beautiful
Jabber: sepp2k / jabber.org
ICQ: 205544826