Jörg Schiemann wrote:

>

[snipped]

> Maybe an example will clearify what I want.
>
> DECLARE VARIABLE RESULT INTEGER;
> BEGIN
> RESULT = 1 OR 4;
> END
>
> RESULT should be 5
>

No, as you have discovered, this cannot be done. The SP language is somewhat
spartan. It primarily supports procedural execution of SQL statements. Pretty
much anything beyond that must be achieved by means of UDFs (as previously
suggested). They are a powerful feature, but can bring a few extra problems.

But to step back a bit, what is it you think you need this for? There may be
another way of achieving your goal.

Paul
--

Paul Reeves
http://www.ibphoenix.com
taking InterBase further