Urgent Help Required

[#1]

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.

[swuehl · Accepted solution]

Please have a look at the string functions in the HELP:

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'

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;