Hello guys,

Say i have have this table:

CREATE TABLE Membre
(noMembre CHAR(8),
nomMembre VARCHAR(30) NOT NULL,
prenomMembre VARCHAR(30) NOT NULL,
adresseMembre VARCHAR(30) NOT NULL,
dateNaissMembre DATE NOT NULL,
dateInscriptionMembre DATE NOT NULL,
adresseCourrielMembre VARCHAR(100),
noClub INTEGER,
PRIMARY KEY (noMembre) ... ... ...

If I want to check that the column say... "nomMembre" has it's first four letters all in uppercase, how can I do it? I was trying with CHECK(UPPER(SUBSTR but i think I'm not using it good...

Any help is appreciated!

Thanx!!!

Stephane