Case-Sensitivity

If your server has a case-insensitive sort order installed, compute ignores the case of the data in the columns you specify.

For example, given this data:

select * from groupdemo

lname      amount 
---------- ------------------ 
Smith                  10.00 
smith                   5.00 
SMITH                   7.00 
Levi                    9.00 
Lévi                   20.00

compute by on lname produces these results:

 select lname, amount from groupdemo
 order by lname
 compute sum (amount) by lname

 lname      amount                   
 ---------- ------------------------ 
 Levi                           9.00 

 Compute Result:
 ------------------------ 
                     9.00 

 lname      amount                   
 ---------- ------------------------ 
 Lévi                          20.00 

Compute Result:
 ------------------------ 
                    20.00 

 lname      amount                   
 ---------- ------------------------ 
 smith                          5.00 
 SMITH                          7.00 
 Smith                         10.00 
 
Compute Result:
 ------------------------ 
                    22.00

The same query on a case- and accent-insensitive server produces these results:

 lname      amount                   
 ---------- ------------------------ 
 Levi                           9.00 
 Lévi                          20.00 

 Compute Result:
 ------------------------ 
                    29.00

 lname      amount                   
 ---------- ------------------------ 
 smith                          5.00 
 SMITH                          7.00 
 Smith                         10.00 

 Compute Result:
 ------------------------ 
                    22.00