Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
My table is containing one column Plant_Name
Plant_Name |
ST. LOUIS FACILITY |
MGF PLAN 1 |
NEWYORK TOWN |
KY VILLAGE BT RD 3 |
All the characters are in uppercase. But i want in following format i.e., one first character of word should be capital
Plant_Name |
St. Louis Facility |
Mgf Plan 1 |
Newyork Town |
Ky Village Bt Rd 3 |
Thanx in advance.
Please have a look at the string functions in the HELP:
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'
So
LOAD
Capitalize(Plant_Name) as Plant_Name,
...
should do what you want.
edit: Or, if you want to read in all field values like this, try FORCE statement:
Force Capitalization;
Please have a look at the string functions in the HELP:
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'
So
LOAD
Capitalize(Plant_Name) as Plant_Name,
...
should do what you want.
edit: Or, if you want to read in all field values like this, try FORCE statement:
Force Capitalization;