Posted by Alexander Kuznetsov on 11/28/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/

• Next in forum: Re: Using a trigger to generate an ID value
• Prev in forum: Help - Finding the newest date without using max()
• Thread view: Re: Help - Finding the newest date without using max()

[Reply to this message]