Upper/Lower Case

[beatlejus]

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

 

[Marco Kalter]

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

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

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

 

[beatlejus]

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

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