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 <li...@itech7.com
<mailto:li...@itech7.com>> 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@postgresql.org
<mailto:pgsql-general@postgresql.org>)
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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general