ASPForums.Net RSS Feedhttp://www.aspforums.net/Handlers/RSS.ashxLatest additions to the content that appears on ASPForums.Net(c) 2019 www.aspforums.com. 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>https://www.aspforums.net:443/Threads/140400/Show-only-records-that-have-NO-text-in-database/https://www.aspforums.net:443/Threads/140400/Show-only-records-that-have-NO-text-in-database/Thu, 28 Feb 2013 04:07:49 GMT