Changing case of string...

[Ajb2528]

Hi!

I hope that someone can help me....

I have a databse table containing rows of company names. What I would like to do is to parse these names to ensure that they are properly capitalised. For example if the name is -

XYZ trading co

I would like the function to return -

XYZ Trading Co

I have tried serveral routines but they all seem to return something like -

Xyz Trading Co

Any help will be appreciated!

Regards,

Alan

 

[SkipVought]

Hi,

What logic do you intend to use to determine that words like XYZ are to be handled differently than words like trading? Use that logic to apply Proper to the words that you intend to capitalize.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}