The use of upper/lower functions in SQL statements can save a lot of
grief!

>>> rbs AT BU DOT EDU 11/30/2004 8:47:29 AM >>>
On Nov 30, 2004, at 8:40 AM, James Choate wrote:

> The scratch column is case sensitive.  Looks like the yes & no are
> capitalized.
>
> The status column is YES|NO|NULL

Such things are prone to change over time: in some releases only
the initial character is capitalized.  We often have to find out
the particulars by trial and error, or getting a syscat columns
listing.

    Richard Sims