Hi Paul,

>> As said: this was an unrelated problem, but the importance lies in
>> what he says about casts. If you have multiple occurences of a
>> named param, _and_ you cast, at every occurence, the field,
>> constant, or whatever you compare the param with, to the same
>> datatype (unless it already has that type explicitly), IBO creates
>> only a single parameter and your problem should be gone.

> That doesn't help - the data types are the same already,

So TERMS and VAT_CLASS are both CHAR(1) ?

> I tried it anyway and it made no difference.

Bugger :-(

You did cast the left hand side, did you - not the param itself?


I wonder why BS behaves well and OC and VC don't. If you move the line
with BS below those with OC and VC, do you get the same result?


Gtrz,
Paul

(out of ideas by now)