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.
Sybase Database Administrator
"The views expressed in this correspondence are mine and not necessarily those of Rabobank International"
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 Caley, System Administrator
Babcock & Brown, Inc., San Francisco
1+512+1515x694 | firstname.lastname@example.org