Michael Peppler
Sybase Consulting
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
Sybase on Linux FAQ
Sybperl FAQ
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,

> -----Original Message-----
> From:	Hugh Caley []
> 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 |