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