How do I make a Pivot Case sensitive?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Green Chameleon - 21 Feb 2006 08:26 GMT

I have data being returned from a SQL view via ODBC (IDS on SuSE) where a
specific field has a value of N and n.

The problem is; only N is showing and all n's are summed in...

How can this be solved?

(O/s = Xp & Office = 2K)

Reply to this Message

keepITcool - 21 Feb 2006 12:50 GMT

include a function in your SQL?

SELECT IIF(strcomp(Field,'n',0),'L','U') AS 'Field', Value
FROM MYTABLE

Signature

keepITcool

| www.XLsupport.com | keepITcool chello nl | amsterdam

> I have data being returned from a SQL view via ODBC (IDS on SuSE)
> where a specific field has a value of N and n.
[quoted text clipped - 4 lines]
>
> (O/s = Xp & Office = 2K)

Reply to this Message

Green Chameleon - 21 Feb 2006 13:16 GMT

Well, what I did was create a union on one view with two
where clauses... One checks for capitals and the other doesn't

ie.:

select column1, column2.... from table_name1 where column2 not in ('a',
'b'...'z')
union all
select column1, column2.... from table_name1 where column2 in ('a',
'b'...'z')

And it works beautifully... Thanx for the reply!

> include a function in your SQL?
>
[quoted text clipped - 11 lines]
> >
> > (O/s = Xp & Office = 2K)

Reply to this Message