PEPPLER.ORG
Michael Peppler
Sybase Consulting
Menu
Home
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
Freeware
Sybperl
Sybase::Simple
DBD::Sybase
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
FAQs
Sybase on Linux FAQ
Sybperl FAQ
Personal
Michael Peppler's resume

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