How to avoid case sensitivity in group by

[Sanjiv Kumar]

Drill Environment:- OS:- Window 10
                   Version:- 1.9
                   Mode:- embedded mode

I have a column name 'State' in db, which have data like(e.g:- Florida,
florida,new jersey, etc).

My problem is while using count(State) and group by in query,
Florida and florida are showing two seperate rows.

So how to avoid case sensitivity so that both  Florida and florida act as 1
rows while firing count(Sate).?


-- 
Thanks & Regards.
Sanjiv Kumar.