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) ?

Yes

>
> > I tried it anyway and it made no difference.
>
> Bugger :-(

Yes

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

I tried both

>
> 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?
>

I've lost that query now having programmed it out although I still have
others which fail - one for example with an integer. I think now Jason will
have to fix this.

Regards
Paul