NULL Wert eines Feldes übersteuern

ID272
Link ReferenceNot set
Link CreditsNot set
Link Technical Documentationhttps://www.techonthenet.com/access/functions/advanced/nz.php
PlCodelangMS Access SQL
PlGroupDatenbank
PlItemTitleNULL Wert eines Feldes übersteuern
CodeSELECT
FieldA
,Nz([FieldB,"This field is null") As FieldB_Nz
FROM TableA
Result Example

FieldA | FieldB_Nz ContentA | This field is null