INITCAP function with few exceptions
Hey i have requirement to initcap the column name; with exception for few
strings.
Source
THE BANK OF AMERICA
BANK OF BARODA
SEABANK OF INDIA
target
The BANK Of America
BANK Of Baroda
SeaBANK of INDIA
in this case i want t Initcap the incoming string but i need to retain the
"BANK" value and "INDIA" as is.
No comments:
Post a Comment