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, ....