The jury consists of Walter M. and John R.

>Gerard,
>
>>As ametter of interest, the Jury seems to be out on whether Stored Procedures are a better tool than code.. you are obviously in the SP camp.
>
>Count me in as being in the SP camp as well, although I don't think that the "jury's still out" on this subject. <g>
>
>~~Bonnie
>
>
>
>>Hi Kevin...
>>I have that working now..thanks
>>
>>As ametter of interest, the Jury seems to be out on whether Stored Procedures are a better tool than code.. you are obviously in the SP camp.
>>I dont rally know enough yet at this stage to make a decison
>>I always kept away from them in VFP. as I thought it would be a limiting factor... having to update a full database (rather than just code) if any 'coding type' changes were mad.
>>
>>regards,
>>
>>Gerard
>>
>>
>>
>>
>>>Hi, Gerard,
>>>
>>>If you want to construct your SQL syntax in your application layer, the syntax would be...
>>>
>>>

>>>string lcSelect = lcSelect = "DOC_DATE BETWEEN '" +  ldFrom.ToString() + "' AND '" + ldTo.ToString() + "'";
>>>

>>>
>>>However, I don't advise this - you're better off building a stored procedure that accepts the 2 dates as parameters (the "@" symbol that you were using is for SQL parameters inside SQL server).
>>>
>>>Kevin