<div>
select count(*) from table<br />
where upper(name) &gt;= upper(:NAME1)<br />
and upper(name) &lt;= upper(:NAME2)
</div>


select count(*) from table
where upper(name) >= upper(:NAME1)
and upper(name) <= upper(:NAME2)

<div>
<div class="content wysiwyg-content">
Hello,<br />
I have a table where the users may enter names in upper and/or lowercase. I could have, for example, NAME1 equal to 'ABEL MARY' and NAME2 equal to 'deBlank John'. The query in the code does the following:<br />
<br />
select count(*) from table<br />
where upper(name) &gt;= :NAME1<br />
and upper(name) &lt;= :NAME2<br />
<br />
but that is obviously resulting in a restricted data set and it does not covers the lowercase names. Considering that the user may type either NAME1 and/or NAME2 with upper or lowercases, how would it be the best way to cover all the data range in the table?<br />
thanks<br />
<br />

</div>
</div>


Hello,
I have a table where the users may enter names in upper and/or lowercase. I could have, for example, NAME1 equal to 'ABEL MARY' and NAME2 equal to 'deBlank John'. The query in the code does the following:

select count(*) from table
where upper(name) >= :NAME1
and upper(name) <= :NAME2

but that is obviously resulting in a restricted data set and it does not covers the lowercase names. Considering that the user may type either NAME1 and/or NAME2 with upper or lowercases, how would it be the best way to cover all the data range in the table?
thanks



Upper and lowercase in a 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.