|
|
sybperl-l Archive
Up Prev Next
From: "Peter Collard" <collardp at rabo-bank dot com>
Subject: RE: Capital letters in Names
Date: May 19 1998 7:02AM
where lower(CompanyName) like lower('Bank of America')
however indexes are ignored, so it table scans.
________________________________________________________
Peter Collard
Sybase Database Administrator
0171-410-3863
"The views expressed in this correspondence are mine and not necessarily those of Rabobank International"
________________________________________________________
-----Original Message-----
From: Hugh Caley [SMTP:hcaley@TDL.COM]
Sent: Monday, May 18, 1998 9:26 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
|
