I have a DBF with a Logical field (ord_sent), and a matching SQL Server table with a bit field of the same name. Is it possible to use the same SELECT command against both tables where I'm referencing the logical/bit field? VFP seems to want .T. or .F., and SQL Server seems to want 0 or 1 (which makes since, since it's a "bit", not a logical). I'm trying to something along the lines of

SELECT *
  FROM qn_head
  WHERE ord_sent = 0

I can't change the field types in the DBF because its used by a legacy system, but I do have complete control over the SQL Server side. Is there any other syntax other than .T. and .F. that I can use to reference the logical field in the DBF? BTW, I'm not doing this in VFP, but in VB using ADO.NET and the VFP OleDb driver. Not sure if that makes any difference or not.

Worse case scenario, I change my VB code to put the SELECT command together differently based on the type of datasource, but I realy don't want to do that. It's much cleaner if I can get the same SQL to work with either datasource.

Thanks in advance for any suggestions.

-----
Lee Perkins