Reply to Re: Help - Finding the newest date without using max()
Posted by Alexander Kuznetsov on 10/21/85 11:58
select TOP 1 notefield, modifiedon
FROM Table1
WHERE id = '100426' and
(statusfield like '%criteria1%' OR
statusfield like '%criteria2%')
ORDER BY modifiedon DESC
-----------------------
Alexander Kuznetsov
http://sqlserver-tips.blogspot.com/