>> I want to force the Gender column to be UPPERCASE but can't figure out how to do it. Any help is GREATLY appreciated <<

> Below is a query I'm working on. I want to force the Gender column to be
> UPPERCASE but can't figure out how to do it. Any help is GREATLY
> appreciated!!
> ---------------------------------------------------------
>
> CREATE TABLE Person
> (PersonID INT CONSTRAINT ROWpk_person PRIMARY KEY,
> LastName NVARCHAR(50) CONSTRAINT ROWnn_person_lname NOT NULL,
> FirstName NVARCHAR(50) CONSTRAINT ROWnn_person_fname NOT NULL,
> Gender NVARCHAR(50) DEFAULT 'F' CONSTRAINT ROWck_person_gender
> CHECK ((Gender='F') or (Gender='M')),
> Weight INT CONSTRAINT ROWck_person_weight
> CHECK ((Weight>84) AND (Weight<251)),
> DateOfBirth DATETIME,
> );

"Tony Rogerson" wrote:

> Assuming you use CHAR(1) and hold F or M instead...
>
> check( ascii( gender ) in ( 70, 77 ) )
>
> "jlewis" <jlewis@discussions.microsoft.com> wrote in message
> news:98B1EFEA-FBBD-438F-BD76-13B2AC3449CF@microsoft.com...
> > Below is a query I'm working on. I want to force the Gender column to be
> > UPPERCASE but can't figure out how to do it. Any help is GREATLY
> > appreciated!!
> > ---------------------------------------------------------
> >
> > CREATE TABLE Person
> > (PersonID INT CONSTRAINT ROWpk_person PRIMARY KEY,
> > LastName NVARCHAR(50) CONSTRAINT ROWnn_person_lname NOT NULL,
> > FirstName NVARCHAR(50) CONSTRAINT ROWnn_person_fname NOT NULL,
> > Gender NVARCHAR(50) DEFAULT 'F' CONSTRAINT ROWck_person_gender
> > CHECK ((Gender='F') or (Gender='M')),
> > Weight INT CONSTRAINT ROWck_person_weight
> > CHECK ((Weight>84) AND (Weight<251)),
> > DateOfBirth DATETIME,
> > );