ifnull

[Ruslan Zasukhin]

On 7/7/08 12:28 PM, "Danny Lewkin" <daniel.lewkin at cognosis.be> wrote:

Hi Danny,

> Hi List,
> 
> because a concat function returns NULL if one of the fields is null,
> I thought I could solve this bij :
> 
> concat(displayname,objptr_typelist,ifnull(objptr_parentid,' '))
> 
> in which I would add a space instead.
> 
> But I still keep getting a error on inserting duplicate rows, and I'm
> certain that objptr_typelist is NOT NULL and has not the same value
> somewhere else already...

You insert the result of concat into some field which is UNIQUE ?


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]