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