>>>>>>Thank you. Hopefully your preferred code works with both VFP and SQL Server. This will make it easier to maintain the code.
>>>>>>
>>>>>No, you still need to maintain 2 different versions.
>>>>
>>>>I see. Thank you for clarifying.
>>>
>>>You could use Cast(Field as Integer) = 1 in both SQL and VFP.
>>
>>Thank you. I didn't realize this could be done. But I am thinking if CASTing will slow down the SQL Select. Because I already decided that I will have two syntax versions (not very difficult), one for VFP and one for SQL. Your approach, of course, has advantage of just one code.
>
>Yes, there is always a trade-off, God does not want us too happy that We could forget about him :)
Well said!
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham