what is COALESCE & how it used with a query give an e.g.

Posted by Sahaj.seema under Sql Server on 3/19/2010 | Views : 2088 | Status : [Member] | Replies : 2
hi all!
anybody tell me whats the use of COALESCE in sql server 2005?
How it is used with queries?




Responses

Posted by: Kumarsudu on: 3/19/2010 [Member] Starter

Up
0
Down
Hi.

Please refer the below link

http://msdn.microsoft.com/en-us/library/ms190349%28SQL.90%29.aspx

Thanks and Regards,
Kumar

Sahaj.seema, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Syedshakeer on: 3/19/2010 [Member] Starter

Up
0
Down
Hi,
check the following linl wiht examples:
http://databases.aspfaq.com/database/coalesce-vs-isnull-sql.html

Syed Shakeer Hussain

Sahaj.seema, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response