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


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.
>    -||-
> Int. Sybase User Group  -||-

Hugh Caley, System Administrator
Babcock & Brown, Inc., San Francisco
1+512+1515x694 |