MS Access SQL replace NULL in field value

Question

I would like to show the value "NONE" if the value in a field is null OR its value if the field is not null from a table using select statement. The statement may be similar to this:

select iif(isnull(spouse),"NONE",spouse) as spouse from biodata

Well, there's a name conflict, in that the alias is the same name as the underlying field. To work, it would have to be more specific: IIf(IsNull(biodata.spouse),"NONE",biodata.spouse) As spouse — David-W-Fenton
– David-W-Fenton, Commented Aug 3, 2011 at 21:07

Jacob · Accepted Answer · 2011-08-02 08:10:14Z

14

SELECT Nz(spouse,"NONE") AS Nzspouse FROM biodata

Nz() replaces spouse with "NONE" if spouse was NULL, otherwise it returns spouse.

answered Aug 2, 2011 at 8:10

Jacob

43.6k6 gold badges81 silver badges81 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

MS Access SQL replace NULL in field value

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related