>>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.

Can you transform Date field to ISO 'yyyymmdd' style (In VFP we have DTOS() function)? and what is Time field? A regular Char of there is such type in ADS?