Initcap function

[PatelRam]

The initcap function sets the first character in each word to uppercase and
the rest to lowercase.

The syntax for the initcap function is:
initcap (string1)
string1 is the string argument whose first character in each word will
be converted to uppercase and all remaining characters converted to lowercase.

For example:

initcap ('tech on the net'); would return 'Tech On The Net'
initcap ('GEORGE BURNS'); would return 'George Burns'

I want to find out what is equivalent in DB2 ??????

How do I implement this in Db2 ...???


Thanks...

 

[blom0344]

The following should work:

UCASE(SUBSTR('GEORGE BURNS',1,1))||LCASE(SUBSTR('GEORGE BURNS',2,(LENGTH('GEORGE BURNS')-1)))

Possibly create an UDF for it?

T. Blom
Information analyst
tbl@shimano-eu.com

 

[KLVIS11]

Sorry, but T.Blom's answer will not work:
the result of his function probably will be:
"George burns" which is not wished.

Stephan

 

[blom0344]

Yep, you are right of course.

Should have read the question better...






T. Blom
Information analyst
tbl@shimano-eu.com

 

[blom0344]

Someone really has gotten to the bottom of it though:

http://www.thefillmoregroup.com/sqlexpand.cfm

T. Blom
Information analyst
tbl@shimano-eu.com