Im hungry, tired and in need of some MS SQL help

Gismo

Hello everyone,

I'm creating a database in access but using SQL... its for my course at uni. I want to set a boolean value: Yes/No. but i don't know how to do this, table i want -

CREATE TABLE CASE(
CASE_ID NUMERIC NOT NULL PRIMARY KEY,
CASE_NAME CHAR (255),
CASE_DESCRIPTION CHAR (1024),
CASE_TYPE_ID CHAR (8), /*(FK)*/
CASE_STATUS (YES/NO), <---- here i want it to be either 'OPEN' or 'CLOSED' instead of 'YES or 'NO' is this possible? but would also like how to do a yes and no, lol
CLIENT_ID NUMERIC, /*(FK)*/
INV_OFF_ID NUMERIC, /*(FK)*/
FEE_ID NUMERIC, /*(FK)*/

Cheers
Dan

JConsulting

here's a blurb straight out of Northwind database. Notice the case for IsDiscontinued. Hope this helps.
J

Expand|Select|Wrap|Line Numbers

 CREATE TABLE Products (

      ProductID int IDENTITY(1, 1) NOT NULL,

      ProductName nvarchar(40) NOT NULL,

      SupplierID int NULL,

      CategoryID int NULL,

      QuantityPerUnit nvarchar(20) NULL,

      UnitPrice money NULL,

      UnitsInStock smallint NULL,

      UnitsOnOrder smallint NULL,

      ReorderLevel smallint NULL,

      Discontinued bit NOT NULL,

      IsDiscontinued AS (case Discontinued when 1 then 'Yes' when 0 then 'No' end)

)

Im hungry, tired and in need of some MS SQL help

re: Im hungry, tired and in need of some MS SQL help

/bytes/development

/bytes/it

/bytes/about