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