The use of upper/lower functions in SQL statements can save a lot of
grief!
>>> [EMAIL PROTECTED] 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
