case sensitivity question

From: Shamir Kanji <shamir_at_canada.com>
Date: Mon, 14 Feb 2000 13:08:52 -0500
Message-ID: <7tXp4.202$X61.3940@news2.tor.primus.ca>

CREATE TABLE AGENT(
  2 AGENTNUMBER NUMBER(4),
  3 AGENTNAME CHAR(10),
  4 OFFICENUMBER NUMBER(3),
  5 AGLEVEL CHAR(2) CHECK(AGLEVEL =
'JR','jr','Jr','jR','SR','sr','Sr','sR'),   6 PRIMARY KEY (AGENTNUMBER),
  7 FOREIGN KEY (OFFICENUMBER) REFERENCES OFFICE); The above does not work - please advise on how to check for upper and lower case...I have spent about 7 hours on it and am getting TiReD!!!!!

Also (not as important), is LEVEL a reserved word?

Thanks,
-sk Received on Mon Feb 14 2000 - 12:08:52 CST