SQL - Select name, no matter upper or lower case letters
<p>I try to select all names with "Schmidt". But some names are lower case and some upper case.</p>

<p>I try this :</p>

<pre><code>Select * from Account
where name like '%chmidt%'
or name like '%CHMIDT%'
</code></pre>

<p>But when one letter inside the word is upper case(e.g. SchmidT), the statement didnt find this.
Know somebody a easy way to solve this problem ? </p>