Upper/Lower Case - Allround Automations forums

Hi,

is it possible to export data to Excel with changing all upper case in lower case or better using an Excel function to convert all upper case in first letter upper and the rest of the statement lower case?

Rgds,
Norbert

------------------
--
Rgds,
Norbert

The only thing I can think of is to use the InitCap SQL function. For example:[quote]

Code

select deptno, 
       initcap(dname) as dname, 
       initcap(loc) as loc
from dept
order by deptno

[/quote]

------------------
Marco Kalter
Allround Automations

Thanks a lot, that's exactly what I'm looking for.

------------------
--
Rgds,
Norbert