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 <sanjivktr@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.
|