I have worked with SQL server. It is a little weird as far as case. If
the table name is really upper case, you must type it upper case (it is
case sensitive, and does not default to upper case) I have been using
it lately in some classes for PeopleSoft, which puts the table names
upper case as per the standard (even if the standard is stupid). We use
Oracle at work, and it defaults to upper case, which is standard, but
ugly. As far as I can tell, the ODBC driver is case insensitive, but
the other tools that access the DB directly are case sensitive, whether
quoted or not. To force case within the ODBC, quote using [] rather
than "". I wish PeopleSoft supported Postgres. It is so much easier to
use.
