Mailing List Archive


Back to the month index Back to the list index
Dug Birdzell (dug@lab.com)
Tue, 11 Nov 1997 23:18:43 -0500 (EST) 

Date: Tue, 11 Nov 1997 23:18:43 -0500 (EST)
From: Dug Birdzell <dug@lab.com>
Subject: Re: CASE INSENSITIVE SEARCHES v2.03
Message-ID: <Pine.GSO.3.93.971111231700.9440A-100000@iron.butterfly.net>

2.0.3 does not provide upper() or lower(). You'd want to use the
CLIKE operator, e.g. select * from PLANETS where name CLIKE 'eArTh'

--dug

On Tue, 11 Nov 1997, Luca Fini wrote:

> On Tue, 11 Nov 1997, Randy A. Katz wrote:
>
> > Hello,
> >
> > I was doing a case insensitive search by SELECT * from tablename WHERE
> > fieldname LIKE '[Dd][Aa][Tt][Aa]' in version 1.0.16. Now in v2.03 it
> > doesn't seem to find anything.
> The LIKE clause needs the SQL syntax for search strings. The above syntax
> iss used for regular expressions instead. MSQL 2 provides a CLIKE clause
> for case insensitive search and a RLIKE for unix like regular expressions
>
> > > In the FAQ it states that something like upper() / lower() would be
> > included in mSQL version 2...how is everyone doing this now???
>
> MSQL 2.0.3 to my knowledge doesn't provide upper() / lower() or
> similar functions.
> Cheers,
> l.f.
>
> --------------------------------------------------------------------------
> -- ) Luca Fini Tel: +39 55 2752 307
> ___ |\ Osservatorio Astrofisico di Arcetri Fax: +39 55 2752 292
> / | | |\_ L.go E.Fermi, 5 o-----------------------------------------
> (___|___//___) 50125 Firenze / WWW: http://www.arcetri.astro.it/~lfini
> (_) (_) Italia / e-mail: lfini@arcetri.astro.it
> -----------------------------o--------------------------------------------
>

Yours,

Dug Birdzell Software Engineer HuskyLabs
dug@lab.com www.butterfly.net/~dug www.lab.com
1 888 HUSKY US, x239 || 1 800 SKYPAGE, pin 419 7381