title: Bracketed Wildcards in tableadapter queries
body: <p>In my TableAdapter I have a SQL Query like below:</p>
  
  <pre><code>SELECT * FROM Vehicles WHERE (VehicleID LIKE @branchList)
  </code></pre>
  
  <p>The Variable i pass to <code>@branchList</code> is a simple join on a few CHARS like <code>ABC</code>
  The problem i have is i need to enclose <code>ABC</code> in Brackets as a need the first character to match any char in the charlist supplied, so i combine the charlist to look like <code>[ABC]%</code>.</p>
  
  <p>below is my VB.NET code to do this and attempt to populate the datagridview:</p>
  
  <pre><code>Try
      Dim br As String = ""
      For Each branch In MenuForm.Branches
          br = br &amp; branch
      Next
      br = "[" &amp; br &amp; "]%"
      Me.VehiclesTableAdapter.FillByBranchList(Me.VehiclesDataSet.Vehicles, br)
  Catch ex As Exception
      MsgBox(ex.Message)
  End Try
  </code></pre>
  
  <p>but this yields no results, but when i copy the query to a SQL Server Editor and declare <code>@branchList</code> like this:</p>
  
  <pre><code>DECLARE @branchList as NVARCHAR(MAX) = '[ABC]%'
  </code></pre>
  
  <p>I get the rows I was expecting.</p>
  
  <p>Am I missing something or is this an issue/limitation with tableadapters?</p>