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