K Dales wrote:
I think there is a fundamental problem with this request: SQL has
no
boolean data type.

Thanks for pointing this out: I don't work directly with T-SQL so I
was not
aware of this limitation; I did mention that the actual formula would
be
dependent on the implementation of SQL used. However any formula
accepted by
T-SQL should work, and I am pretty sure there must be some formula
that will
yield the proper result.

Trying to be sneaky here... Rather than using a SQL Server connection,
I instead connected to the workbook, i.e. used a MS Jet connection
which *does* support a BOOLEAN data type, then used Jet's ODBC
pass-through functionality to connect to the SQL Server table then cast
as a Boolean in Jet e.g.

SELECT IIF(MyBitCol<0,TRUE,FALSE)
FROM [ODBC;DSN=SQLServer_Airplanes].MyTable;

No luck, though. MS Query still returned the values to the worksheet as
numeric values.

Jamie.

--