>And because it should be SQL Server compliant try:
>That is of course if DateSaved is datetime field.
>BTW Why not just use Datetime field?
Well I have been witholding some information :) It is not VFP and it is not SQL Server, it is ADS (Advantage Database).
I am stuck with a table and need to extract some data from it. I only have to do it once so I do not care if it is efficient..
Anywho, there is a DateSaved field (not datetime, just date) and a TimeSaved field (not datetime, just time). I seem to recall that VFP also had just date and just time fields before. ADS is based on DBase like Fox was.
Anywho I got side tracked on my quest for a query but I am hoping to get a chance to look into it this afternoon.
Semper ubi sub ubi.