I would use a BIT field (1/0).
You can use a Varchar(3) or CHAR(3) and insert Yes / No.
Useing a CHAR(3) will "waste" space as it'll pad the right with a space when you have a no.
Bit is the best option.
Cheers,
Crispin
Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!