<div>
You can use Proper() function for your operation.<br />
<br />
Regards,<br />
Chetan Sachdeva
</div>


You can use Proper() function for your operation.

Regards,
Chetan Sachdeva

<div>
<div class="content wysiwyg-content">
Have the following query:<br />
<br />
select name from table_name whre name like %somestring%<br />
<br />
The values in name can be upper and lower case. &nbsp;I find when running this query that it is case-sensitive. &nbsp;That is, somestring has to be uppercase if name is uppercase. <br />
<br />
How can I make this query less case-sensitvie?
</div>
</div>


Have the following query:

select name from table_name whre name like %somestring%

The values in name can be upper and lower case.  I find when running this query that it is case-sensitive.  That is, somestring has to be uppercase if name is uppercase. 

How can I make this query less case-sensitvie?

Case sensitive like query

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.