Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 4F84F4760AB for ; Wed, 29 Jan 2003 23:56:37 -0500 (EST) Received: from mail02.up.edu.ph (unknown [210.14.43.1]) by postgresql.org (Postfix) with SMTP id ECA40475F00 for ; Wed, 29 Jan 2003 23:56:35 -0500 (EST) Received: (qmail 28886 invoked by uid 504); 30 Jan 2003 05:27:09 -0000 Received: from ryanne.cruz@up.edu.ph by web2 with qmail-scanner-1.01 (update: v4245 29 Jan 2003. Clean. Processed in 0.45644 secs); 30 Jan 2003 05:27:09 -0000 Received: from unknown (HELO b01.mail.up.edu.ph) (10.16.3.1) by 10.16.3.144 with SMTP; 30 Jan 2003 05:27:08 -0000 Received: (qmail 23458 invoked by uid 504); 30 Jan 2003 04:59:20 -0000 Received: from ryanne.cruz@up.edu.ph by b01 with qmail-scanner-1.01 (update: v4245 29 Jan 2003. Clean. Processed in 0.433323 secs); 30 Jan 2003 04:59:20 -0000 Received: from unknown (HELO localhost) ([10.16.3.5]) (envelope-sender ) by 10.16.3.1 (qmail-ldap-1.03) with SMTP for ; 30 Jan 2003 04:59:19 -0000 Received: from 10.33.187.83 ( [10.33.187.83]) as user rocruz1@b04.mail.up.edu.ph by mail.up.edu.ph with HTTP; Thu, 30 Jan 2003 13:09:38 +0800 Message-ID: <1043903378.3e38b392b4422@mail.up.edu.ph> Date: Thu, 30 Jan 2003 13:09:38 +0800 From: ryanne cruz To: "\\\"pgsql-php@postgresql.org\\\"" Subject: Re: underscore MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit User-Agent: Internet Messaging Program (IMP) 3.1 X-Originating-IP: 10.33.187.83 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/87 X-Sequence-Number: 1832 hi list! i have a column wherein a lot of entries has 2 or more names int it. these are separated by spaces. an example is: "John Doe", "Mary Margaret Smith". i need to replace the spaces with an underscore. any idea how to do this? thanks! ryanne