How to make Upper case first letter and rest lower Case

system · September 17, 2009, 11:18pm

I have one object called Client Name,I want to make First letter Upper and Rest as Lower Case Like Below:
Newyork.
Dc
Nj

Thank you in Advance.

Pooja

ktm (BOB member since 2008-11-12)

system · September 18, 2009, 12:15am

You’ll need to tell us what database you are using?

Do you also realise that you can do this within the BO report itself using the WordCap() function.

plessiusa (BOB member since 2004-03-22)

system · September 18, 2009, 12:21am

We are Using My SQL. Can You Give me the Syntax of WordCap() function as well as making the Object in Universe.

Thanks
Pooja

ktm (BOB member since 2008-11-12)

system · September 18, 2009, 12:48am

WordCap is the function within BO.

=WordCap([dimension])

Sorry I don’t know MYSQL at all, I would suggest searching Google to see if you can find a SQL Reference manual for it so that you can find the SQL Command that you will need.

plessiusa (BOB member since 2004-03-22)

system · September 18, 2009, 1:12am

MySQL 5.0 Online Reference

MySQL String Functions

In reading that list you’ll see there is no InitCap or WordCap function, so what you will have to do is combine Upper(), Lower(), and Substring() to do the job. Use Substring() to get the first character of the string, use the Upper() function to convert it to upper case, use the Substring() function to get the rest of the string (after the first character) and use the Lower() function to convert it to lower case. Combine the two pieces together with the Concat() function.

Dave Rathbun (BOB member since 2002-06-06)

system · September 18, 2009, 5:15am

I have no idea about MY SQL but, in oracle you can achieve using INITCAP() function at universe level.

Try this if ti works for MY SQL also.

Rakesh_K (BOB member since 2007-12-11)

system · September 18, 2009, 5:58am

I think you missed Dave’s post where he has already answered the question.

plessiusa (BOB member since 2004-03-22)

system · September 21, 2009, 5:57pm

MY column from Data base is comming like ‘’ Business Object Report"
Starting Letter is in Upper and rest is in Lower.
I want to make all UPEER Case LIKE “BUSINESS OBJECT REPORT”.

Should i need to USE UPPER(column/tablename) in the select statement?

Thanks
Pooja

ktm (BOB member since 2008-11-12)

system · September 21, 2009, 6:18pm

This sort of question could be answered in five minutes of your own time, simply by trying it out. You can also review the MySQL function list I linked earlier to see a discussion of the various functions and what they do. With examples.

Dave Rathbun (BOB member since 2002-06-06)