|
|
sybperl-l Archive
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
the array.
I hope this helps,
Eric
> -----Original Message-----
> From: Hugh Caley [SMTP:hcaley@tdl.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
>
> --
> Hugh Caley, System Administrator
> Babcock & Brown, Inc., San Francisco
> 1+512+1515x694 | hughc@babcockbrown.com
>
|
