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: Michael Peppler <mpeppler at MBAY dot NET>
Subject: Capital letters in Names
Date: May 18 1998 8:34PM

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