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...
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
> 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.
> Steven Wechsler/Sybase DBA/Sanford C. Bernstein & Co., Inc.
> "Never underestimate the power of human stupidity" - Lazarus Long
> Support the Anti-SPAM amendment: http://www.cauce.org
> > -----Original Message-----
> > From: Hugh Caley [SMTP:firstname.lastname@example.org]
> > 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 | email@example.com
Hugh Caley, System Administrator
Babcock & Brown, Inc., San Francisco
1+512+1515x694 | firstname.lastname@example.org