> 1) Is it case sensitive? y/n/optional? Yes - everything is case sensitive. > 2) Multiple WHERE's? > > ... WHERE Approved="Y" OR City="San Jose" AND State="Ca" This is legal - you can use ()'s as well to make sure it compares in the proper order... > 3) Boolean? > > ... WHERE NOT Approved="Y" I actually never tried this... good question though... Jason