Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 69A70476178 for ; Tue, 27 Aug 2002 19:18:40 -0400 (EDT) Received: from moutng.kundenserver.de (moutng.kundenserver.de [212.227.126.183]) by postgresql.org (Postfix) with ESMTP id D91EA4760CE for ; Tue, 27 Aug 2002 19:18:39 -0400 (EDT) Received: from [212.227.126.160] (helo=mrelayng0.kundenserver.de) by moutng5.kundenserver.de with esmtp (Exim 3.35 #2) id 17jpbT-0002Oc-00; Wed, 28 Aug 2002 01:18:31 +0200 Received: from [213.7.174.58] (helo=zwerg98) by mrelayng0.kundenserver.de with asmtp (Exim 3.35 #2) id 17jpbS-0003LO-00; Wed, 28 Aug 2002 01:18:30 +0200 Message-ID: <004301c24e20$7d622820$7f54fea9@zwerg98> Reply-To: "Cornelia Boenigk" From: "Cornelia Boenigk" To: "Joseph L Montes" , References: <1030488967.3913.3.camel@joey> Subject: Re: Looking for help Date: Wed, 28 Aug 2002 01:20:42 +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 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200208/84 X-Sequence-Number: 1429 Hi Joseph > but What happens > if I only want to select a couple of fields. Then you tell the server which fields you want to select;-) SELECT field1, field2, ... , fieldn FROM table ... > how do you select from a table that is not all lower case what do you mean? what is not all lower case? PostgreSQL returns the contents of the fields as they are. If you need the results to be in lower case use SELECT lower(fieldx), lower(field2),... FROM table respectively SELECT upper(field1), upper(field2), ... FROM table. See chapter 4.4 of the PostgreSQL user's Guide for more. The PHP-Functions to change case are strtoupper() and strtolower(). Hope it helps Regards Conni