Hi Helen, thanks for your suggestion.

Yes, the field is constrained to upper case, but I tried your
suggestion anyway, to no avail.

Is my code OK though?

SELECT MONITOR FROM STOCK
WHERE STK_ID = :S_ID
INTO isMon;

This *should* put the value of 'monitor' into my CHAR(1) var, isMon
shouldn't it?

-Ryan

>
> Are you sure that the Monitor value is constrained to be upper

case? What

> happens if you specifically test it case-insensitively, e.g.
> ..
> IF (UPPER(isMon) = 'N') THEN
> BEGIN
> EXCEPTION PART_NOT_MON;
> EXIT;
> END
>
> heLen