T-SQL query to search table-field for "Keywords"
<p>I'm trying to create a search text-box on my website than when submitted will pass the 'string-keyword' into my grid and pull all matching records for that keyword.</p>

<p>I'm having to setup my grid with a where statement that will "listen" for parameters passed in by the form via query-string.</p>

<p>I'm not sure how to approach this. Any insight, tips, examples appreciated.</p>

<p>UPDATE-------
This is the query my grid is using to populate records. In addition to City/Region/Country I'm trying to incorporate a keyword Search that would only look at my 'Company' Field inside the BND_Listing table. </p>

<pre><code>select * FROM BND_listing right join BND_ListingCategories
on BND_Listing.CatID=BND_ListingCategories.CatID
where 
 (CategoryName = '[querystring:filter-Category]' or '[querystring:filter-     Category]'='All')
 and
 (City = '[querystring:filter-City]' or '[querystring:filter-City]'='All')
and
(Region= '[querystring:filter-State]' or '[querystring:filter-State]'='All')
and
(Country= '[querystring:filter-Country]' or '[querystring:filter-    Country]'='All')
and
isnull(Company,'') &lt;&gt; ''
ORDER by Company ASC
</code></pre>