Re: Oracle Table Noob Question :(

This straight off the cuff and may not work.

Just wondering whether you tried using the "upper" function

//tc

"Nikki" <netranger28_at_hotmail.com> wrote in message news:YBMDa.9861$3Sm.8420_at_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!
>
>
Received on Fri Jun 06 2003 - 15:40:02 CEST