convert a Nz from MS Access to a zero-length string.

[jennyha23]

convert a Nz from MS Access to a zero-length string.

Hello, I am migrating the Access queries in SQL server views.
This is a query in Access:
SELECT emp_name, nz(emp_address)
FRM employee

Do you know how to convert this in SQL server VIEW? especially "nz"....
Thanks.
Jenny.