Emma,
Assuming that each description is in a single field; ie - field named "X" 
for instance
.
show all the records that you need to change - this operation will work on 
the selected set of records only
place cursor inside field "X"
under the "Records" menu item choose "Replace Field Contents"
in the dialog box that appears choose "Specify"
in the calculation dialog box type in  Proper (X) ...... X being name of 
field where you want to make changes
click OK
click "Replace"
.
For your future reference, just like Upper (field name) makes all the text 
upper case and lower (field name) makes all the text lower case,
Proper (field name) makes all the text proper case........ 1st word 
capitalized, etc.
.




From:
Emma Glaisher <[log in to unmask]>
To:
[log in to unmask]
Date:
09/29/2010 07:49 AM
Subject:
Sentence case



I have several thousands records looking like:

• Provides Chilled And Ambient Water
• Bottle Not Included

Which I need to change to:

• Provides chilled and ambient water
• Bottle not included

I think I just have to start creating a complicated calculation, but if 
anyone knows a great tip, I’d be very grateful!

Cheers
Emma 


Emma Glaisher
Artworker and Database Development - Fourninety Limited
Tel: 0113 238 2447
http://www.fourninety.com/
The Media Centre, Nepshaw Lane South, Morley, Leeds, West Yorkshire, LS27 
7JQ

Media Square plc or any of its subsidiary companies may not be held 
responsible for the content of this email as it may reflect the personal 
view of the sender and not that of the company. Should you receive this 
email in error, please notify the sender immediately and do not disclose, 
copy or distribute it. While Media Square plc scans all outbound emails 
for viruses, it cannot be held responsible for any infected files that you 
may receive. Media Square plc advises all recipients to virus scan any 
file attachments.

Fourninety Limited, a member company of the Media Square plc group. 
Registered in England No. 3737606. Registered address 6 York Street, 
London, W1U 6PL

This email message has been scanned and delivered safely by Mimecast.