[dba-SQLServer]Nz in a SQL Query

Look into using the T-SQL IsNull function.

Chris Mackin
Denver Database Consulting, LLC
www.denverdb.com




-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com]On Behalf Of Mark Boyd
Sent: Wednesday, April 23, 2003 9:43 AM
To: SQLServerList
Subject: [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.