lower and upper is not a solution which i am aspecting. I want to display same output as i get through sql server management studio
On Wed, Feb 8, 2017 at 5:15 PM, Sanjiv Kumar <sanjiv...@gmail.com> wrote: > 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. > -- Thanks & Regards. Sanjiv Kumar.
