Hi, I am trying to insert into a column in a mssql 7 database with a datatype of "bit"... I have tried to insert 0, 1, '0', '1' but get an sql error every time ("Incorrect syntax near ...")... I also tried first using settype and setting my variables type to boolean (which seems to me to be the nearest to 'bit' from the available choices) but this gave the same sql error... Has anyone managed to do an insert like this? Are there any tricks I should be aware of? TIA, Kelvin. -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]