Say i have have this table:
CREATE TABLE Membre
nomMembre VARCHAR(30) NOT NULL,
prenomMembre VARCHAR(30) NOT NULL,
adresseMembre VARCHAR(30) NOT NULL,
dateNaissMembre DATE NOT NULL,
dateInscriptionMembre DATE NOT NULL,
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!
Click Here to Expand Forum to Full Width