Casespecific Column

Database

Casespecific Column

I would like to create a column in my table that has only UPPER case data and converts any lowercase data entered to UPPERCASE. Is it possible to do that in the create table statement and what is the syntax?
2 REPLIES
Senior Apprentice

Re: Casespecific Column

Hi Chichi,
it's exactly the syntax you used :-)

col varchar(x) UPPERCASE

Dieter

Re: Casespecific Column

Thank you so much.