Jet SQL to SQL Server - True/False for Ticks? 1

[Stevehewitt]

Hi Guys,

I have numberous tick boxes in my database, which is all on Access at the moment. However, I'm testing upsizing my backend file to SQL Server Express 2005 as the amount of data we are putting on the database is stretching Jet a bit too much.

The problem is that a lot of my queries and filters in VBA use -1 or 1 to do counts etc. on the tick box fields.

How do these work in SQL Server?

Any help appreciated!

Cheers,




Steve.

"They have the internet on computers now!" - Homer Simpson

 

[cmmrfrds]

Sql server returns a 1 for true and 0 for false.

 

[Stevehewitt]

Thanks,

Steve.