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: 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
>