Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

upper-/lower-case

Status
Not open for further replies.
andreako

andreako

Programmer
Jun 14, 2001
27
0
0
NO
Hi!

I wonder if anybody can help me with this:

In my report I select data from the database, but I would very much like to format the text in the report. You see now it comes out with only uppercase, but I would like it to be only the first letter that is uppercase and the rest to be lowercase.
Is there any way to solve this in Oracle reports 6.0?!
If not, how may I solve this in an other way?!

Thanks in advance!

andreako
 
Sort by date Sort by votes
in your query use function Initcap(columnname)

which will convert the selected column from whatever format to Init Cap.

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

soushi01
  • Locked
  • Question
Oracle reports bulider cannot use CASE WHEN statement 1
Replies
4
Views
88
soushi01
soushi01

Part and Inventory Search

Sponsor

Back
Top