>Good catch.
>
>I've started writting a method that will convert a VFP Select to a Sql Select. It does not cover every case, but I'm adding to it each time I find something in my situation that I can easily deal with using basic string functions.
>
>I know there is a page on fox.wikis.com that has a comparison page and I am referring to that too as I encounter each case.
In order to avoid that, you may want to parameterize the SQL select. So, no matter if this is a Bit in SQL Server or a Logical in VFP, you would then be able to pass your parameter value as if, based on the environment you are sitting in. For example, if VFP, I was passing .F. for the parameter. In VB.Net, I am passing False. But, in SQL Server, it is stored in 0 and 1. And, that works.