ifnull

[Danny Lewkin]

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

Any idea's?

Greetz,

Danny