Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id C8D1C9FB7F7 for ; Mon, 19 Feb 2007 11:54:18 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-new, port 10024) with ESMTP id 14705-07 for ; Mon, 19 Feb 2007 11:54:06 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from lists.commandprompt.com (host-254.commandprompt.net [207.173.203.254]) by postgresql.org (Postfix) with ESMTP id 33CA79FB9C4 for ; Mon, 19 Feb 2007 11:54:11 -0400 (AST) Received: from perhan.alvh.no-ip.org (216-155-79-222.bk1-dsl.surnet.cl [216.155.79.222]) (authenticated bits=0) by lists.commandprompt.com (8.13.7/8.13.6) with ESMTP id l1JFs9td002220; Mon, 19 Feb 2007 07:54:09 -0800 Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000) id 05A8232A00; Mon, 19 Feb 2007 12:54:07 -0300 (CLST) Date: Mon, 19 Feb 2007 12:54:06 -0300 From: Alvaro Herrera To: Shavonne Marietta Wijesinghe Cc: Bart Degryse , pgsql-sql@postgresql.org Subject: Re: Uppercase and Lowercase Message-ID: <20070219155406.GO28395@alvh.no-ip.org> Mail-Followup-To: Shavonne Marietta Wijesinghe , Bart Degryse , pgsql-sql@postgresql.org References: <001001c75439$b7749b50$1102a8c0@dream> <45D9CF8C.A3DD.0030.0@indicator.be> <002701c7543c$2a888730$1102a8c0@dream> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <002701c7543c$2a888730$1102a8c0@dream> User-Agent: Mutt/1.5.13 (2006-08-11) X-Virus-Scanned: ClamAV version 0.88.5, clamav-milter version 0.88.5 on projects.commandprompt.com X-Virus-Status: Clean X-Greylist: Sender succeded SMTP AUTH authentication, not delayed by milter-greylist-1.6 (lists.commandprompt.com [192.168.2.159]); Mon, 19 Feb 2007 07:54:10 -0800 (PST) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.206 tagged_above=0 required=5 tests=AWL, BAYES_50, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200702/198 X-Sequence-Number: 27532 Shavonne Marietta Wijesinghe wrote: > Hey thanks Bart. it worked ;) > > but sadly what it does is changes "VIA SENATO" in to "Via senato" but what i need is "Via Senato" > > Anyoneeeeeee?? initcap() does what you want. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support