Case sensitive

[jenn1030]

Hello

Does anyone have any idea how to make a field be displayed in the proper case to write a letter. The issue is that names and address all come out in upper case. If I use the format Aa* that will capitalize the first letter, which works fine when it is only one word. When it is more than 1 word it looks like this: Horn lake. Any suggestions?

 

[griffindm]

Jenn,

If your database supports it, Impromptu should show another database-specific function that could handle it. In Oracle it is initcap.

Dave G.

The Decision Support Group
Reporting Consulting with Cognos BI Tools
"Magic with Data"
Want good answers? Read FAQ401-2487 first!

http://www.decisionsupportgroup.com