Up Prev Next
From: Eric Johanson <ERICJ at AMC-DIRECT dot COM>
Subject: RE: Capital letters in Names
Date: May 18 1998 9:32PM
Well, from perl you can convert any string to lowcase...
I don't know if this is the best way, but you could do a lookup of all the
names, into an array, convert the array to all lower case.. and then search
I hope this helps,
> -----Original Message-----
> From: Hugh Caley [SMTP:email@example.com]
> Sent: Monday, May 18, 1998 1:11 PM
> To: SybPerl Discussion List
> Subject: Capital letters in Names
> Sorry if this is a bit simplistic for this list.
> My users want to do queries of Company names in one of our databases.
> The queries must ignore case; however, various words in the name may or
> may not be capitalized (such as Bank of America).
> Can anyone suggest a good way to do this? I can't find a way to do a
> case-insensitive query to the database...
> Hugh Caley, System Administrator
> Babcock & Brown, Inc., San Francisco
> 1+512+1515x694 | firstname.lastname@example.org