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