Re: case sensitivity question

For checking on multiple values use the IN operator not the =

so

AGLEVEL CHAR(2) CHECK( AGLEVEL in ('JR','jr','Jr','jR','SR','sr','Sr','sR') ),

should do it...

and yes, LEVEL is a reserved word - used in the 'connect by' construct for hierarchies....

hth,

"Shamir Kanji" <shamir_at_canada.com> 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
>
>

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 80,000 Newsgroups - 16 Different Servers! =----- Received on Mon Feb 14 2000 - 12:41:00 CST