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: Hugh Caley <hcaley at tdl dot com>
Subject: Re: Capital letters in Names
Date: May 18 1998 9:41PM

This fixes my problem.  Thank you to the several kind people who answered.  I
guess my local SQL guru didn't understand my question about this...

Hugh

Michael Peppler wrote:

> Hugh Caley writes:
>  > 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...
>
> You *can* do a case insensitive query using lower() or upper(), but be
> aware that this will likely not use any indexes that you may have on
> the name field.
>
> See the SQL server reference manual, in the string functions section.
>
> Michael
> --
> Michael Peppler         -||-  Data Migrations Inc.
> mpeppler@datamig.com    -||-  http://www.mbay.net/~mpeppler
> Int. Sybase User Group  -||-  http://www.isug.com



--
Hugh Caley, System Administrator
Babcock & Brown, Inc., San Francisco
1+512+1515x694 | hughc@babcockbrown.com