Re: Replace null values

On 03/23/2010 10:07 AM, John R Pierce wrote:
> Nilesh Govindarajan wrote:
>> Hi,
>>
>> In my query, some rows have null values (length 0).
>
> a NULL value is not length 0, NULL is not the empty string, rather, NULL
> is no value at all.
>
> if you want to change a 0 length string to something, use a CASE or
> something.
>
> select CASE WHEN u.name = '' THEN 'anon' ELSE u.name, ....
>
>
>
>
>

Thanks a lot ! It worked :)

--
Nilesh Govindarajan
Site & Server Administrator
www.itech7.com