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 <[email protected] <mailto:[email protected]>> 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 ([email protected] <mailto:[email protected]>) 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 ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
