equivalent function of inticap() in qlikview

[jelly_gvm]

Hi All,

is there any similar or equivalent function of  inticap()(SQL function) is avaliable in qlikview

Thanks,

[swuehl · Accepted solution]

You mean Initcap() function, right?

Please check the Help for all string functions, then you should get around

capitalize(s )

Returns the string s with all words capitalized.

Example:

capitalize ('my little pony') returns 'My Little Pony'

capitalize ( 'AA bb cC Dd') returns 'Aa Bb Cc Dd'

[jelly_gvm]

sorry to say delay response

thanks a lot