[dba-SQLServer]Nz in a SQL Query

Mark Boyd MarkBoyd at McBeeAssociates.com
Wed Apr 23 16:12:15 CDT 2003


Chris -
Thanks for the input.
This pretty much does the same thing as using Nz.

Mark

-----Original Message-----
From: Chris Mackin [mailto:chris at denverdb.com] 
Sent: Wednesday, April 23, 2003 12:20 PM
To: dba-sqlserver at databaseadvisors.com
Subject: RE: [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.



_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com



More information about the dba-SQLServer mailing list