>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 ???
>
>Thanks for your help
I think this may work:
SELECT TOP 1 *
FROM MyTable
WHERE Product = ?Parm1
ORDER BY ChangedDate DESC
Chris McCandless
Red Sky Software
