From: "TC" <donotuse@donotuse.com>
Newsgroups: comp.databases.oracle
References: <YBMDa.9861$3Sm.8420@news01.bloor.is.net.cable.rogers.com>
Subject: Re: Oracle Table Noob Question :(
Lines: 27
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
Message-ID: <SQ0Ea.1132444$F1.135990@sccrnsc04>
NNTP-Posting-Host: 12.250.123.140
X-Complaints-To: abuse@attbi.com
X-Trace: sccrnsc04 1054906802 12.250.123.140 (Fri, 06 Jun 2003 13:40:02 GMT)
NNTP-Posting-Date: Fri, 06 Jun 2003 13:40:02 GMT
Organization: AT&T Broadband
Date: Fri, 06 Jun 2003 13:40:02 GMT


This straight off the cuff and may not work.

Just wondering whether you tried using the "upper" function

//tc

"Nikki" <netranger28@hotmail.com> wrote in message
news:YBMDa.9861$3Sm.8420@news01.bloor.is.net.cable.rogers.com...
> Hi everyone,
>
> I'm looking for help with this table,
>
> create table model(modelcode char(5), modelname char(10), type char(2) not
> null, sizefeet number(6) not null, bedrooms number(5) not null
> check(bedrooms between 2 and 5), lotsize number(2) not null,primary key
> (modelcode,modelname));
>
> I need to make  the column TYPE accept only BU, DE or TH and allow both
> upper and lower case. I use a check to make it accept the BU,DE,TH but
 when
> it comes to accepting upper and lower case I'm  stuck. if anyone can help
 so
> that it meets the requirement above that would be greatly appreciated TIA!
>
>