Sorry guys,

I forgot to mention that I was walking about Access - cheers Ken.

barry


-----Original Message-----
From: Ken Schaefer [mailto:ken@a...] 
Sent: 30 November 2001 01:27
To: sql language
Subject: [sql_language] Re: String Concatination in Select statement

NZ() is an Access function that does the same thing as ISNULL() in SQL
Server.

Cheers
Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "SAMMY MSAFIRI" <sammy@s...>
Subject: [sql_language] Re: String Concatination in Select statement


: This Nz() dont seem to exist in SQL Server 7.0 in which version did
you
get
: it.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~



teambanana@b...
$subst('Email.Unsub')

Read the future with ebooks at B&N
http://service.bfast.com/bfast/click?bfmid=2181&sourceid=38934667&catego
ryid=rn_ebooks