null value

[Anonymous]

Hello everyone

I wrote these  three commands but it don't work correctly

First line count M_compositionID

Second line count M_compositionID that are not null

Third line count M_compositionID that are null

I will appreciate if any one can help me.

[jonathandienst]

Well as long as none of the real P_Nationalcodes are = 1 !

That's why I recommend a separate flag field to avoid confusing your users and possibly corrupting your data.

[Anonymous]

thank you for your guidance

[Anonymous]

thank you for your guidance

[Anonymous]

thank you for your guidance

[Anonymous]

thank you for your guidance

[Anonymous]

thank you for your guidance