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

Thanks.  Just what I was looking for!

Evidently the local Sybase guru didn't understand my question when I asked
him about this...

Hugh

Wechsler, Steven M wrote:

> in SQL, you can use "select * from tablename where lower(name) like
> 'name_in_lower_case" or "select * from tablename where upper(name) like
> 'NAME_IN_UPPER_CASE"
>
> to perform a case-insensitive search.  However, it can be slow, because
> it will not be able to use indexes on that column.
>
> You can also change your sort order to be case insensitive (if you're
> not SA, you'll have to ask your SA to do it), but then you won't be able
> to do case sensitive matches - sort order is a server-level option.
>
> HTH,
>
> Steve
> --
> Steven Wechsler/Sybase DBA/Sanford C. Bernstein & Co., Inc.
> WechslerSM@bernstein.com
> "Never underestimate the power of human stupidity" - Lazarus Long
> Support the Anti-SPAM amendment: http://www.cauce.org
>
> > -----Original Message-----
> > From: Hugh Caley [SMTP:hcaley@tdl.com]
> > Sent: Monday, May 18, 1998 4: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
> >



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