>>>This one works
>>>
>>>

>>>SELECT COUNT(*)
>>>FROM [dbo].[log]
>>>WHERE action = 'THIS' AND log_date_time BETWEEN
>>>    '2008/01/01' AND '2008/03/31'
>>>
>>>

>>
>>I didn't say it wouldn't. I said it is not the right way to do that.
>>Cetin
>
>Cetin,
>
>But I was wondering, is there a method that would work for either VFP database or SQL Server without having to maintain two different approaches?

Yes, use parameters:) That is a single codebase approach and yet safe.
Cetin