Re: More DB Q's.

["Pete St. Onge" <pete@seul.org>]

Aaron Turner wrote:
> 
> Ok, remember that SELECT on WHERE Approved="Y" ?
> 
> A few things:
> 
> 1) Is it case sensitive? y/n/optional?
     Assuming that Approved is a string variable, it would likely be
case sensitive.

> 2) Multiple WHERE's?
> 
> ... WHERE Approved="Y" OR City="San Jose" AND State="Ca"
     Suggest use parentheses to delineate clauses.

      WHERE Approved="Y" OR (City="San Jose" AND State="Ca");

> 3) Boolean?
> 
> ... WHERE NOT Approved="Y"
    WHERE Approved <> "Y"

    might work instead.

    hth

    Pete

-- 
Pete St. Onge
pete@seul.org