Oracle Table Noob Question :(

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 Thu Jun 05 2003 - 21:11:52 CEST