Upper/Lower Case - Allround Automations forums

Register Log In

Forums Products Query Reporter Upper/Lower Case

Print Thread

Upper/Lower Case #32313 06/25/03 05:12 PM
Joined: Mar 2003 Posts: 20 Germany beatlejus OP Member
OP beatlejus Member Joined: Mar 2003 Posts: 20 Germany	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 Regards, Norbert

Re: Upper/Lower Case #32314 06/25/03 11:06 PM
Joined: Aug 1999 Posts: 22,208 Marco Kalter Member
Marco Kalter Member Joined: Aug 1999 Posts: 22,208	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 Marco Kalter Allround Automations

Re: Upper/Lower Case #32315 06/26/03 11:04 AM
Joined: Mar 2003 Posts: 20 Germany beatlejus OP Member
OP beatlejus Member Joined: Mar 2003 Posts: 20 Germany	Thanks a lot, that's exactly what I'm looking for. ------------------ -- Rgds, Norbert Regards, Norbert

Moderated by support

Link Copied to Clipboard

Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)

Responsive Width:

PHP: 7.1.33 Page Time: 0.020s Queries: 14 (0.006s) Memory: 2.5000 MB (Peak: 3.0378 MB) Data Comp: Off Server Time: 2024-05-06 00:50:43 UTC
Valid HTML 5 and Valid CSS