ASPForums.Net RSS Feed additions to the content that appears on ASPForums.Net(c) 2019 All rights reserved.Show only records that have NO text in database<p>Ok you will need to write this query</p> <pre class="brush: sql">SELECT Behcode FROM Behcode WHERE Date = (SELECT MAX(Date) FROM Behcode WHERE Behcode BETWEEN 1000 AND 1005 AND Reserved = &#39;No&#39;)</pre> <p>and check whether it works</p>, 28 Feb 2013 04:07:49 GMT