At 03:42 AM 14-10-02 +0000, you wrote:

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

Yup. If you haven't already, try this query out in a client query tool
that shows you a result set:

SELECT MONITOR FROM STOCK
WHERE STK_ID = <the constant value>

But I guess you already tried this. I can't see anything in your SP which
would cause its results to differ from what you see in an interactive query.

Are you sure the S_ID parameter is being passed correctly? Is it for
example a case-sensitive string that is getting mangled by your application
code?

heLen