[dba-SQLServer]Nz in a SQL Query

Is there another way to express the Nz function in a SQL query?

For example, how would I calculate the following:

'UPDATE tblTable1 SET [tblTable1].[Col1] = nz([Col2]) + nz([Col3])'

 

TIA,

Mark Boyd

Sr. Systems Analyst

McBee Associates, Inc.

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/dba-sqlserver/attachments/20030423/b41545fc/attachment.html>