Home Forums Programming General Yes/No field in sql server table what is the same RE: Yes/No field in sql server table what is the same

  • 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!