Urgent Help Required

Fri, 01 Feb 2013 16:21:25 GMT

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.

Re: Urgent Help Required

swuehl — Fri, 01 Feb 2013 16:23:57 GMT

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'

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;