How do I make a Pivot Case sensitive?
 

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)

How do I make a Pivot Case sensitive?
 

include a function in your SQL?

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

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


Green Chameleon wrote in


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)

How do I make a Pivot Case sensitive?
 

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!

"keepITcool" wrote:


include a function in your SQL?

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

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


Green Chameleon wrote in


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)