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.How to match blank field value in MS Access Database Query WHERE Clause<p>Hi baijuep,<br /><br />first try</p> <pre class="brush: sql">qstr18 = &#34;select count(*) from PersData where coy=&#39;tata motors&#39;and OutDetails like &#39;&#39;&#34;</pre> <p>here I removed the blank space from the two single quotes.</p> <p>Still it dont resolved.</p> <p>also get check that the value of&nbsp; OutDetails indeed ' ' and not null, because ' ' is not null.</p> <p>thanks and Regards,</p> <p>Rk_Hirpara.</p>https://www.aspforums.net:443/Threads/116198/How-to-match-blank-field-value-in-MS-Access-Database-Query-WHERE-Clause/https://www.aspforums.net:443/Threads/116198/How-to-match-blank-field-value-in-MS-Access-Database-Query-WHERE-Clause/Thu, 09 May 2013 03:35:35 GMT