Up Prev Next
From: "Mark Gendein" <markg at altair dot net>
Subject: RE: Capital letters in Names
Date: May 19 1998 11:55AM
I saw some of the other responses and they will be fine if your table is
small, otherwise the punishment for not using the index will be great. You
also mention that users are doing these queries. I might suggest creating a
view for them as they will not be at all familiar with the system functions.
One solution I have used is to create another column (like SearchName), and
maintain it from a trigger. The trigger is responsible for UPPER casing the
name and copying it to the other column. You can then index the column if
Just some thoughts.
From: SYBPERL-L@listproc.net [mailto:SYBPERL-L@listproc.net]
Sent: Monday, May 18, 1998 1:19 PM
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 Caley, System Administrator
Babcock & Brown, Inc., San Francisco
1+512+1515x694 | firstname.lastname@example.org