I would index the ChangeDate field, then grab that value (vardate = ChangeDate), then do the SQL with ... AND ChangeDate = vardate.
Chuck
>In SQL Server, What would be my Statement to retreive a record with the latest date ?
>
>Someting Like This : Select * From MyTable Where Product = ?Parm1 And ???ChangedDate Is The Latest ???
Today is tomorrow's yesterday.
