Hello,
i used this function in BO 6.5.4 and we wanna Change to BI 4.2.
But there is only LCase in IDT.
Somebody has any idea to get this Text: ABCDEFGH to Abcdefgh?
By the way, it is really pity - that the Forum goes to retire.
BR
Steffen
Steffen11 (BOB member since 2011-02-16)
In the subject you said “Webi” but in the body you said “IDT”. Which tool are you using?
In any event, it is an available function in WebI.
In IDT, the list of available functions will depend on the database middleware that you’re using. Also, the list of available functions in the SQL editor is somewhat expanded – the function is identified as “Initial Caps”, although adding it to the expression will actually use the proper name “initcap”.
joepeters 
(BOB member since 2002-08-29)
Hello,
i mean IDT 4.2 SP7 in combination with Oracle 11.
Before, with the old Designer (6.5.4) there was a function initcap(String), but now i am missing it.
I have a String “HELLO WORLD” and i want to have “Hello World”.
Do u know what i mean?
Maybe do u have also i idea - how do i can find a alternative function for: decode? I miss it too…
Thank u.
BR
Steffen
Steffen11 (BOB member since 2011-02-16)
It should be there – I am using BI4.2 SP06 with an Oracle connection, and I see “Initial Caps” as an available function.
Note that you can use any function that the database supports, whether or not it’s listed in the available functions in the SQL editor. Just type it in the object definition.
joepeters (BOB member since 2002-08-29)
You mean here?
I get a error message…
Also for:
Unknown Function.
Steffen11 (BOB member since 2011-02-16)
[Moderator Note: Moved from Web Intelligence to Semantic Layer / Universe Designer]
Marek Chladny 
(BOB member since 2003-11-27)
OH - you’re using Multi Source. That’s different. Multi Source has its own SQL syntax which is very limited. There is no native function like InitCap. If it’s just one field, you can add a Calculated Column to the underlying table and do the initcap() there. Just be sure to check off the “Use database-specific SQL” in the dialog.
joepeters (BOB member since 2002-08-29)
Wow!
Perfect - it was a very good Idea!
Many thanks.
By the way, do you also know how I could insert a translation table?
I have one Column for example:
A
B
C
And i want to Have
A Product 1
B Product 2
C Product 3
I could create a new table on Oracle, but it are only arround 10 rows.
Thank u.
BR
Steffen
Steffen11 (BOB member since 2011-02-16)
I would think some sort of CASE statement would work. Just a thought.
kevlray (BOB member since 2010-06-23)
You could create a derived table, ex:
select ‘A’ as code,‘Product 1’ as desc from dual union
select ‘B’ as code,‘Product 2’ as desc from dual union
…
joepeters (BOB member since 2002-08-29)