Up Prev Next
From: Michael Peppler <mpeppler at MBAY dot NET>
Subject: Re: text searching
Date: Mar 4 1998 1:10AM
philip mikal wrote:
> 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?
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 Peppler -||- Data Migrations Inc.
firstname.lastname@example.org -||- http://www.mbay.net/~mpeppler
Int. Sybase User Group -||- http://www.isug.com