|
|
sybperl-l Archive
Up Prev Next
From: "Wechsler, Steven M" <WechslerSM at bernstein dot com>
Subject: RE: Capital letters in Names
Date: May 18 1998 8:23PM
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
>
|
