Mailing List Archive


Back to the month index Back to the list index
Annette Maile (maile@rus.uni-stuttgart.de)
Mon, 26 Apr 1999 15:26:22 +0200 

Message-ID: <3724697E.807CE101@rus.uni-stuttgart.de>
Date: Mon, 26 Apr 1999 15:26:22 +0200
From: Annette Maile <maile@rus.uni-stuttgart.de>
Subject: lower case function?

Hello list,

is there any possibility in lite to convert a string to lower case?
(I'm using msql 2.0.8)

TIA
Annette
From rarwes@dds.nl Mon Apr 26 09:51:19 1999
Received: from mailhost.rug.nl (mailhost.rug.nl [129.125.4.6])
        by services.bunyip.com (8.8.5/8.8.5) with SMTP id JAA12723
        for <msql-list@services.bunyip.com>; Mon, 26 Apr 1999 09:51:19 -0400 (EDT)
Received: from dep.ub.rug.nl by mailhost.rug.nl with local-SMTP (MMTA) with ESMTP;
          Mon, 26 Apr 1999 15:51:11 +0200
Received: from ub1.ub.rug.nl by dep.ub.rug.nl (PAA11862);
          Mon, 26 Apr 1999 15:51:11 +0200 (MET DST)
Received: from UB1/SpoolDir by ub1.ub.rug.nl (Mercury 1.21);
          26 Apr 99 15:53:58 +0100
Received: from SpoolDir by UB1 (Mercury 1.21); 26 Apr 99 15:53:33 +0100
Received: from dds.nl by ub1.ub.rug.nl (Mercury 1.21) with ESMTP;
          26 Apr 99 15:53:30 +0100
Sender: s1036289@dds.nl
Message-ID: <37246F34.D1696A6@dds.nl>
Date: Mon, 26 Apr 1999 15:50:44 +0200
From: Rutger Wessels <rarwes@dds.nl>
X-Mailer: Mozilla 4.5 [en] (X11; I; HP-UX B.10.20 9000/735)
X-Accept-Language: nl, en
MIME-Version: 1.0
To: msql-list@services.bunyip.com
Subject: Re: lower case function?
References: <3724697E.807CE101@rus.uni-stuttgart.de>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Annette Maile wrote:
>
> Hello list,
>
> is there any possibility in lite to convert a string to lower case?
> (I'm using msql 2.0.8)
>
> TIA
> Annette

$string = tr($string, "A-Z", "a-z")

Rutger
From lecorre@magic.fr Mon Apr 26 09:52:17 1999
Received: from bagdad.magic.fr (bagdad.magic.fr [195.115.17.10])
        by services.bunyip.com (8.8.5/8.8.5) with ESMTP id JAA12818
        for <msql-list@services.bunyip.com>; Mon, 26 Apr 1999 09:52:14 -0400 (EDT)
Received: from lecorre (ppp-31.net3.magic.fr [195.115.18.31])
        by bagdad.magic.fr (8.8.8/8.8.8) with SMTP id PAA04718
        for <msql-list@services.bunyip.com>; Mon, 26 Apr 1999 15:52:11 +0200 (MET DST)
Message-ID: <001101be8feb$e3a9dfc0$0100a8c0@lecorre.magic.fr>
From: "F.L." <lecorre@magic.fr>
To: "msql" <msql-list@services.bunyip.com>
Subject: N# of results ?
Date: Mon, 26 Apr 1999 15:16:16 +0200
MIME-Version: 1.0
Content-Type: text/plain;
        charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3

Hi,

is there a simple instruction to display the number of valid results in a
query ?

ex. result : Bambi
                       Fernando
                       Joshua

gives : 3 (matches found)

Thanks
Fabrice Le corre
webmaster@wallis-islands.com