title: SQL query to ignore case in where condition
body: <p>I am trying to run below SQL query.$1 would be the passing parameter. I would need that to be case insensitive. for eg:</p>
  
  <p>test.sql server1.net and test SERVER1.NET ( Both values should be taken, I think now the below query only takes the parameter in lowercase by default)
  So my requirement is, irrespective of the case, whatever values I have given, query should process. Please help ?</p>
  
  <pre><code>select * from act_msgs m,node_name nn
  where msg_name like '%test%'
  and nn.node_name = '$1'
  </code></pre>