Access NZ() function to SQL Server equivalent

What is the SQL Server equivalent to Access NZ() function?

Access SQL
NZ([Event Timestamp])

SQL Server Equivalent
COALESCE([Event Timestamp],0)ISNULL([Event Timestamp],0)

* do not confuse this with the Access isnull() function.