Kevin,
Why not let them enter their names like they want to and use UCASE or
LCASE when comparing the search parameter with the field from the query?
Add LIKE, and you're set.
Try something like:
<CFIF #SearchEntry# IS NOT "">
lcase(LINK) LIKE '%#lcase(SearchEntry)#%'
</cfif>
in the WHERE clause of your query. This will return partial matches
entered in any combination of upper/lower case.
--John Allred
"Parker, Kevin" wrote:
>
> 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.
--
John Allred / Jackson, Mississippi
Webmaster, Mississippi Counties
http://www.mscounties.com/
------------------------------------------------------------------------------
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.
