thandel

<div>
try like:<br />
<br />

<pre><code id="code-20-42667931-1">sSql = &quot;SELECT * FROM tClaim WHERE ClaimNo Like '*&quot; &amp; Replace(Trim(sLab),&quot;'&quot;,&quot;''&quot;) &amp; &quot;*' &quot;</code></pre>
</div>


try like:



sSql = "SELECT * FROM tClaim WHERE ClaimNo Like '*" & Replace(Trim(sLab),"'","''") & "*' "

<div>
Thanks I edited my question and had removed the equal sign but missed the single quotes.... that worked thanks Paul!
</div>


Thanks I edited my question and had removed the equal sign but missed the single quotes.... that worked thanks Paul!

<div>
anyway...<br />
<br />
this part : &nbsp;<br />
<br />

<pre><code id="code-20-42667934-1">Like &quot; &amp; &quot;'*&quot; </code></pre>
<br />
can be simplified to as what I already shown
</div>


anyway...

this part :  



Like " & "'*" 


can be simplified to as what I already shown

<div>
<div class="content wysiwyg-content">
I am trying to run an SQL command ... I have it working as:<br />
<br />
sSql = &quot;SELECT * FROM tClaim WHERE ClaimNo = &quot;&nbsp;&amp; &quot;&quot;&quot;&quot;&nbsp;&amp; sLab &amp;&nbsp;&quot;&quot;&quot;&quot;<br />
<br />
but I need to do a wild card search and trim the variable..... so I tried this:<br />
<br />
sSql = &quot;SELECT * FROM tClaim WHERE ClaimNo Like &quot;&quot;&nbsp;* &quot;&quot;&nbsp;&amp; Trim(sLab) &amp;&nbsp;&quot;&quot; * &quot;&quot;&quot;<br />
<br />
This just ends up freezing up MS Access.<br />
<br />
What is wrong with my SQL statement looking for a wild card?<br />
<br />
Thank you.
</div>
</div>


I am trying to run an SQL command ... I have it working as:

sSql = "SELECT * FROM tClaim WHERE ClaimNo = " & """" & sLab & """"

but I need to do a wild card search and trim the variable..... so I tried this:

sSql = "SELECT * FROM tClaim WHERE ClaimNo Like "" * "" & Trim(sLab) & "" * """

This just ends up freezing up MS Access.

What is wrong with my SQL statement looking for a wild card?

Thank you.

SQL Syntax

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

HTTPS is a protocol for secure communication over a computer network which is widely used on the Internet. HTTPS consists of communication over Hypertext Transfer Protocol (HTTP) within a connection encrypted by Transport Layer Security (TLS) or its predecessor, Secure Sockets Layer (SSL). The main motivation for HTTPS is authentication of the visited website and to protect the privacy and integrity of the exchanged data. HTTPS is widely used for protecting page authenticity on all types of websites, securing accounts and keeping user communications, identity and web browsing private.

SSL / HTTPS

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.