Hi all -- I am using MS SQL 2000 and cannot use the BIT data type because the software accessing the data will not recognize it. I will be storing a 1 or a 0 in the column and basing queries on the contents of that column in tables that will be large but not extremely large. I also cannot use any other variation of integer other than INT (no TINYINT, for example). What would be best to use, CHAR(1) or INT? I'm looking for the best performance. Thank you!