Case Statement

[Former Member]

Is it possible to write a case statement like the following:

Case table_size.

when 0.

when > 0 and < 1000.

when > 1000 and <2000.

when others.

endcase.

[Former Member]

No, you can not. You have to write If statement in this case.

Regards,

Satish

[Former Member]

No, I don't think you can use CASE like this

Instead you need to go for IF

-Pavan

[Former Member]

You can not use the ">" or "<" symbols in the Case statements, they are unknown and will be treated like a field thats been defined by a data statement. Its simply easier to use the conditional IF/ELSE/ENDIF statements when dealing with ranges.

[JozsefSzikszai]

you have to use IF ... :

IF tablesize EQ 0.

...

ELSEIF tablesize GT 0 AND tablesize LT 1000.

...

ELSEIF ...

ENDIF.

hope this helps

ec