I've set up a system where people can lodge their abstracts electronically
for an international congress being held here next year.
I've now added a facility to that so that web site users can search those
abstracts. One of the search fields is a lookup on author surname which I
derive from the database itself. The problem is that everyone out there who
has submitted an abstract has their own idea about how they should type
their surname in and in a list they all look rather untidy. I've tried to
standardise the look of them by adding this bit of code to the lookup.
#UCase(Mid(Name,1,1))##LCase(Mid(Name,2,Len(Name)-1))#
Works OK but trouble is that MacDonald becomes Macdonald, von Trapp becomes
Von trapp and O'Brien becomes O'brien.
Any tips on how I can improve this please.
+++++++++
Kevin Parker
Service and Communication
WorkCover Corporation
[EMAIL PROTECTED]
www.workcover.com
ph: +61 8 82332548
fax: +61 8 82332000
mob: 0418 800 287
++++++++++
****************************************************************************
This e-mail is intended for the use of the addressee only. It may contain
information that is protected by legislated confidentiality and/or is
legally privileged. If you are not the intended recipient you are prohibited
from disseminating, distributing or copying this e-mail. Any opinion
expressed in this e-mail may not necessarily be that of the WorkCover
Corporation of South Australia. Although precautions have been taken, the
sender cannot warrant that this e-mail or any files transmitted with it are
free of viruses or any other defect.
If you have received this e-mail in error, please notify the sender
immediately by return e-mail and destroy the original e-mail and any copies.
****************************************************************************
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
