>anyone,
>how do you write an SQL statement to be passed to sqlserver7 to group by date only without the time in datetime interfering in the process ?
select < aggregate >, < aggregate > from MyTable group by Convert(Char(10),MyDatetimefield,101)
You can use most any expression in the Group By clause with SQL Server and the field does not have to be in the field list (as it does in VFP).
HTH.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao