On 03/23/2010 12:17 PM, Sreelatha G wrote:
Hi, select case when name='' then null end from table; Thanks Sreelatha On Tue, Mar 23, 2010 at 12:03 PM, Nilesh Govindarajan <lists@xxxxxxxxxx <mailto:lists@xxxxxxxxxx>> wrote: On 03/23/2010 11:47 AM, John R Pierce wrote: How to convert zero length string to null ? UPDATE yourtable SET name=NULL WHERE name=''; No I don't want to replace it in the table. Just in the query result. -- Nilesh Govindarajan Site & Server Administrator www.itech7.com <http://www.itech7.com/> -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx <mailto:pgsql-general@xxxxxxxxxxxxxx>) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Thanks ! -- Nilesh Govindarajan Site & Server Administrator www.itech7.com -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general