<div>
Hello, thanks for looking at this.<br />
<br />
With your help I've got it to work but I'm struggling to understand the following.<br />
<br />
If I use:-<br />
<br />
&quot;&nbsp;Dim strFind As String<br />
&nbsp; &nbsp; &nbsp; &nbsp; strFind = Trim(txtPostcode.Text) + &quot;%&quot;<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp; Me.SiteDetailsTableAdapter<wbr />.FillBy(Me<wbr />.OilDistri<wbr />butionSyst<wbr />emDataSet.<wbr />SiteDetail<wbr />s, strFind)&quot;<br />
<br />
it doesn't work. &nbsp;However if I use:-<br />
<br />
&nbsp;Dim strFind As String<br />
&nbsp; &nbsp; &nbsp; &nbsp; strFind = Trim(txtPostcode.Text) + &quot;%%%%%%&quot;<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp; Me.SiteDetailsTableAdapter<wbr />.FillBy(Me<wbr />.OilDistri<wbr />butionSyst<wbr />emDataSet.<wbr />SiteDetail<wbr />s, strFind)<br />
<br />
it does work. &nbsp;I thought the &quot;%&quot; should match any string.
</div>


Hello, thanks for looking at this.

With your help I've got it to work but I'm struggling to understand the following.

If I use:-

" Dim strFind As String
        strFind = Trim(txtPostcode.Text) + "%"

        Me.SiteDetailsTableAdapter.FillBy(Me.OilDistributionSystemDataSet.SiteDetails, strFind)"

it doesn't work.  However if I use:-

 Dim strFind As String
        strFind = Trim(txtPostcode.Text) + "%%%%%%"

        Me.SiteDetailsTableAdapter.FillBy(Me.OilDistributionSystemDataSet.SiteDetails, strFind)

it does work.  I thought the "%" should match any string.

<div>
In SQL % is any string, but in VB.net % is any character. <br />
<br />
Try using * instead.
</div>


In SQL % is any string, but in VB.net % is any character.

Try using * instead.

<div>
Thanks for clarifying that and your help.
</div>


Thanks for clarifying that and your help.

<div>
<div class="content wysiwyg-content">
Hello<br />
<br />
I'm adding a query with a filter to a dataset with the designer.<br />
<br />
My query is:-<br />
<br />
SELECT &nbsp; &nbsp;Counter, SiteRef, ccount, SiteName, AddressLine1, AddressLine2, AddressLine3, Town, Postcode<br />
FROM &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;SiteDetails<br />
WHERE &nbsp; &nbsp; &nbsp; &nbsp;(Postcode = @POSTCODETOFIND )<br />
<br />
This works OK but I'm struggling to get the LIKE and wildcard option to work.<br />
<br />
Please could you suggest the correct syntax.<br />
<br />
Thanks
</div>
</div>


Hello

I'm adding a query with a filter to a dataset with the designer.

My query is:-

SELECT    Counter, SiteRef, ccount, SiteName, AddressLine1, AddressLine2, AddressLine3, Town, Postcode
FROM            SiteDetails
WHERE        (Postcode = @POSTCODETOFIND )

This works OK but I'm struggling to get the LIKE and wildcard option to work.

Please could you suggest the correct syntax.

Thanks

Wildcard in dataset filter query

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.