<div>
I agree % is the db wild card of choice<br />
* is used less frequently - and &quot;Thats my final answer Regis&quot;<br />
;)<br />
ché<br />
wootton<br />
<br />
(sorry - it had to be said)<br />

</div>


<div>
<div class="content wysiwyg-content">
 &nbsp;WHERE [Name] LIKE 'S*' &nbsp; works in my Access 2000 database<br />
in VB6 + ADO 2.1 it returns empty recordset, but if I modifie SQL to<br />
WHERE [Name] LIKE 'SecurID' it works fine<br />
what is the issue with * over here<br />
Sincerely,<br />
Matt<br />

</div>
</div>


  WHERE [Name] LIKE 'S*'   works in my Access 2000 database
in VB6 + ADO 2.1 it returns empty recordset, but if I modifie SQL to
WHERE [Name] LIKE 'SecurID' it works fine
what is the issue with * over here
Sincerely,
Matt


I agree % is the db wild card of choice
* is used less frequently - and &quot;Thats my final answer Regis&quot;
;)
ché
wootton

(sorry - it had to be said)


* in LIKE clause

  WHERE [Name] LIKE &#39;S*&#39;   works in my Access 2000 database
in VB6 + ADO 2.1 it returns empty recordset, but if I modifie SQL to
WHERE [Name] LIKE &#39;SecurID&#39; it works fine
what is the issue with * over here
Sincerely,
Matt


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.