SQL more... problem with <NULL> V4MD1

[Florian Bogeschdorfer]

I see. I guess it would be IFNULL(CRD_Number,0) ?

Where would I insert that in the SQL string?

TIA, Florian

> >
> > SELECT NAME,CRD_NUMBER FROM KUNDEN,KARTEN WHERE KD_ID*=CRD_KD_ID REPLACE
> > VALUE <NULL> WITH 0
> 
> It seems there was function ifnull()
> 
> Which do what you ask for
> 
>