ASPForums.Net RSS Feed additions to the content that appears on ASPForums.Net(c) 2019 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>, 09 May 2013 03:35:35 GMT