[dba-SQLServer]IsNull

Both IsNull and Coalesce are in SQL 7 T-SQL Help  and are not listed 
as new functions  so they must have been in 6.5 at least.



On 7 May 2003 at 11:00, Haslett, Andrew wrote:

> Pretty sure its been around for a while.  There's also COALESCE()
> which seems to be preferred these days..
> 
> Cheers,
> Andrew
> 
> -----Original Message-----
> From: Susan Harkins [mailto:harkins at iglou.com]
> Sent: Wednesday, 7 May 2003 9:46 AM
> To: SQLList
> Subject: [dba-SQLServer]IsNull
> 
> 
> Does anyone know how long IsNull's been around -- forever? Or is it
> new to 2000 -- I only have 2000 installed.
> 
> Susan H.
> 
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
> 
> IMPORTANT - PLEASE READ ******************** 
> This email and any files transmitted with it are confidential and may
> contain information protected by law from disclosure. If you have
> received this message in error, please notify the sender immediately
> and delete this email from your system. No warranty is given that this
> email or files, if attached to this email, are free from computer
> viruses or other defects. They are provided on the basis the user
> assumes all responsibility for loss, damage or consequence resulting
> directly or indirectly from their use, whether caused by the
> negligence of the sender or not.
> _______________________________________________ dba-SQLServer mailing
> list dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
> 


-- 
Lexacorp Ltd
http://www.lexacorp.com.pg
Information Technology Consultancy, Software Development,System 
Support.