Mixing case on an address field 1

[meckeard]

Hi all,

I have to convert this value:

120 WEST ROAD

to this:

120 West Road (note change in case)

using a select statement. I was able to convert the first letter of a first and last name using the IIF function but addresses tend to start with a number and consist of multiple words.

Is this possible? If so, can anyone help me with this?

Thanks.

 

[lespaul]

See Thread701-1247907

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases:
The Fundamentals of Relational Database Design
Understanding SQL Joi

 

[meckeard]

That worked. Thanks!