DSXchange

Hello,

I want to do an initcap on a particular column in transformer.

I m doing it using CONVERT function for columns that has fixed values

For instance
How do I go about for columns whose values are not fixed?

Pl suggest

TIA

There's nothing out of the box, but it would be a fairly straightforward parallel routine to write.

Consider your business rules, though. InitCap might also need to occur after certain other characters, like O'Brien or Sarbanes-Oxley.

Then there are the exceptions, such as fforbes-Hamilton, MacDonald or "de Gaulle".

What level of complexity do you require?

Vick, yet again there is a need for a C routine

Thanks

Psst....no hijacking It will depend upon the complexity, as Ray mentioned.