Hi All,
Is there a Function in WebFOCUs to convert the String to InitCap.
Eg: "CAR" to "Car" and "COUNTRY" to "Country"

Regards,
MSAM

there is in most databases, or you can create a function on your database to do it.

I'm not sure about webfocus, it's just another option.

There is a function that converts words, I'm home so don't have the exact name, believe it is LCWORD

Thanks for the Info Jason !!!

I think you wnat to use the function lcword like this.

DEFINE FILE CAR
KOUNTRY/A10=LCWORD(10,COUNTRY,'A10');
END
TABLEF FILE CAR
PRINT COUNTRY KOUNTRY
END

COUNTRY KOUNTRY
------- -------
ENGLAND England
FRANCE France
ITALY Italy
JAPAN Japan
W GERMANY W Germany

good luck

et

In WebFOCUS the function is called LCWORD.

The syntax:

LCWORD(length, string, outfield)

An example:

SYSTEMDESC/A40 = LCWORD(40, SYSTEM_DESC, 'A40');

Take a look at "Character Functions" in the Function Reference document.

Thank you All .It's working i,e LCWORD...

Regards,
MSAM

msam: sorry, I suppose since your original post even referenced the oracle (?) function InitCap, you probably already know that you can do this in the SQL world.