>SHAMIN WROTE:
>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
>
>
>Yes, level is a reserved word. Try
...constraint check_aglevel check(aglevel in('JR','SR', ...etc);
HtH
sandy
>
>
>
>
>
>
Received on Mon Feb 14 2000 - 12:42:14 CST
