ALTER TABLE Syntax - Add Yes/No Field 1

[idbr]

Hi,

Hopefully a simple one for someone - does anyone know the correct description to use to create a yes/no field using ALTER TABLE?

e.g. ALTER TABLE tblMatchedSellerDescriptions ADD COLUMN Match DATA_TYPE_HERE

Thanks in advance, Iain

 

[r937]

ALTER TABLE tblMatchedSellerDescriptions
ADD COLUMN Match YESNO

rudy | r937.com | Ask the Expert | Premium SQL Articles
SQL for Database-Driven Web Sites (next course starts March 6 2005)

 

[idbr]

D'oh! Thanks Rudy...

 

[PHV]

Or:
ALTER TABLE tblMatchedSellerDescriptions ADD COLUMN Match BIT;
Or:
ALTER TABLE tblMatchedSellerDescriptions ADD COLUMN Match BOOLEAN;

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244