Did you try select lower(columnname) from tbl ? ex: select lower(clientnum) from tblcase where clientnum = 'WAZ'
Joel Fradkin Wazagua, Inc. 2520 Trailmate Dr Sarasota, Florida 34243 Tel. 941-753-7111 ext 305 [EMAIL PROTECTED] www.wazagua.com Powered by Wazagua Providing you with the latest Web-based technology & advanced tools. C 2004. WAZAGUA, Inc. All rights reserved. WAZAGUA, Inc This email message is for the use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and delete and destroy all copies of the original message, including attachments. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Scott Marlowe Sent: Thursday, February 24, 2005 4:07 PM To: Zouari Fourat Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] lowercase function lower() On Thu, 2005-02-24 at 14:57, Zouari Fourat wrote: > Hello, > Am looking for a 'tolowercase' function that returns lowercase string > that can be used like this : > > SELECT lowercase(column) FROM table; > > anyone can help me ? > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED]) ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
