<div>
&quot;Select all * from table &nbsp;WHERE cuenta = null and costo &gt;&nbsp;'1000'&quot; <br />
<br />

</div>


"Select all * from table  WHERE cuenta = null and costo > '1000'"



<div>
i was using vbnull instead of null<br />
<br />
nice!<br />
<br />

</div>


i was using vbnull instead of null

nice!



<div>
I am glad I can help.<br />
If you have Questions in the future you can ask at shayplace@hotmail.com and I can post some of them on <a href="http://www.hili.com/~shay/link/vbcoerner.htm" rel="ugc">http://www.hili.com/~shay/link/vbcoerner.htm</a><br />

</div>


I am glad I can help.
If you have Questions in the future you can ask at shayplace@hotmail.com and I can post some of them on http://www.hili.com/~shay/link/vbcoerner.htm [http://www.hili.com/~shay/link/vbcoerner.htm]


<div>
<div class="content wysiwyg-content">
i have a 5mb DBF &nbsp;and i like to make an sql query to select all the records that have a cost bigger than 1000 and the shipment description is in blank.<br />
i have something like this but it's not working...<br />
&quot;Select all * from table &nbsp;WHERE cuenta ='' and costo &gt;&nbsp;0&quot;<br />
in concrete:<br />
how do i make a query to select &nbsp;records with an empty string?
</div>
</div>


i have a 5mb DBF  and i like to make an sql query to select all the records that have a cost bigger than 1000 and the shipment description is in blank.
i have something like this but it's not working...
"Select all * from table  WHERE cuenta ='' and costo > 0"
in concrete:
how do i make a query to select  records with an empty string?

sql query in vb5 enterprise sp3

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.