<div>
Text = &quot;'&quot; &amp;&nbsp;123 &amp;&nbsp;&quot;'&quot;<br />
Data1.RecordSource = &quot;SELECT * FROM Customer WHERE AccountNo LIKE &quot;&nbsp;&amp; Text &amp;&nbsp;&quot; &quot;<br />

</div>


Text = "'" & 123 & "'"
Data1.RecordSource = "SELECT * FROM Customer WHERE AccountNo LIKE " & Text & " "


<div>
More clearly:<br />
FilterInfo = &quot;'&quot; &amp;&nbsp;123 &amp;&nbsp;&quot;'&quot; <br />
Data1.RecordSource = &quot;SELECT * FROM Customer WHERE AccountNo LIKE &quot;&nbsp;&amp; FilterInfo<br />

</div>


More clearly:
FilterInfo = "'" & 123 & "'"
Data1.RecordSource = "SELECT * FROM Customer WHERE AccountNo LIKE " & FilterInfo


<div>
Also, what database are you using? &nbsp;If it's access, the %'s from the earlier comment should be astericks. &nbsp;<br />

</div>


Also, what database are you using?  If it's access, the %'s from the earlier comment should be astericks.  


<div>
Kamall: Sorry, I can't give the points to you.<br />
1) The source code gives error, b'cos of the wrong SQL command.<br />
You need the ' after the LIKE <br />
eg. Just like the one in my example.<br />

</div>


Kamall: Sorry, I can't give the points to you.
1) The source code gives error, b'cos of the wrong SQL command.
You need the ' after the LIKE
eg. Just like the one in my example.


<div>
NB. If you are using the Access, use the * instead of the % for matching.<br />

</div>


NB. If you are using the Access, use the * instead of the % for matching.


<div>
<div class="content wysiwyg-content">
how can I get this to work in VB<br />
Filterinfo = &quot;%123%&quot; 'match 123<br />
&nbsp; &nbsp; Data1.RecordSource = &quot;select * from [Customer] where [AccountNo] like '&quot; &amp;&nbsp;filterInfo &amp;&nbsp;&quot;'&quot;<br />

</div>
</div>


how can I get this to work in VB
Filterinfo = "%123%" 'match 123
    Data1.RecordSource = "select * from [Customer] where [AccountNo] like '" & filterInfo & "'"


How to filter using select statement with like

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.