Concatenating fields that may contain NULL

[Craig]

I am connecting to an Access DB using ODBC.

In my SQL statement I have Field1 + ' ' + Field2 and a field is NULL it
returns NULL

1 field may contain NULLs

So NULL + "Text" = NULL

How can I make NULL + "Text" = "Text" and treat NULL as empty string or ""?

 

[Robert P.]

SELECT iif( isnull(myNullField), "", myNullField ) FROM myTable

 

[Craig]

Thanks. I was trying iff instead of iif. Need to do this more often!!!