>>I am having the issue with date field while accessing VFP table from ASP (thru VBScript). The following statement
>
>Can you try a universal approach?
>
>
>SELECT * FROM tblAbc WHERE trans_date => {^11/21/2006} AND trans_date <= {^11/27/2006}
>
Thank a lot. This one is works as well as without '^'.