sybperl-l Archive

From: Michael Peppler <mpeppler at MBAY dot NET>
Subject: Re: text searching
Date: Mar 4 1998 1:10AM

philip mikal wrote:
> 
> Hello:
> 
> Thank you for your answer.
> 
> > > How do I accomplish ignoring case?
> >
> > You can use the lower() or upper() t-sql functions, or you can
> > turn your SQL server to case-insensitive.
> 
> I wish to use a "case-insensitive" option so a search string of "audio"
> would match both "Audio" and "audio", but myself nor the individual
> managing the database I am using know where/how this is set.  How do I set
> this option on a SunOS 5.6 machine?

Two options:

Code your queries to do something like
	$word = lc($word);

	where lower(field_name) like "%$word%"

Or define a case-insensitive sort order. See the Sybase sys-admin
manuals for this.

Michael
-- 
Michael Peppler         -||-  Data Migrations Inc.
mpeppler@datamig.com    -||-  http://www.mbay.net/~mpeppler
Int. Sybase User Group  -||-  http://www.isug.com