Michael Peppler
Sybase Consulting
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
Sybase on Linux FAQ
Sybperl FAQ
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

From: Thanasis Bothos <thanasis at uclink4 dot berkeley dot edu>
Subject: Re: text searching
Date: Mar 3 1998 11:09PM

One way to handle this is to configure your Sybase server to set its sort
order to 'case insensitive.

Thanasis Bothos
UC Berkeley

At 10:51 AM 3/3/98 PST, you wrote:
>This might be slightly off topic...
>I have a web site where I allow searching through my Sybase database
>via a HTML form and Sybperl.  Currently I have it working by 
>using "like '%$search_string%'", but I wish to increase the functionality
of it 
>by allowing boolean and/or of the search words and the ability to 
>ignore case. I believe that I could accomplish the and/or function 
>by splitting apart the words from the search string and then having 
>an sql statement for each search word joined with a union. Is this 
>the best way to do this?  How do I accomplish ignoring case?  
>Philip Mikal