Use Wildcard to filter query results
<p>I have a dropdown created with results from a ColdFusion query. I am trying to figure out how to remove assoc_last names that begin with Test*. Is it possible to put a <code>WHERE assoc_last = "test*"</code> and have that remove values containing "test" in that database, like "testby" and so on? </p>

<pre><code>&lt;cfquery name="GetActiveEmps" datasource="dsn"&gt;
        SELECT assoc_userid, assoc_last, assoc_first FROM tco_associates
        WHERE assoc_status = 'ACTIVE'
        and WHERE assoc_last LIKE 'Test%' 
        and len(assoc_last) &gt; 0
        ORDER BY assoc_last
    &lt;/cfquery&gt;    
</code></pre>