Accces Null Zero equiv in SQL Server 1

[dndaughtery]

I have the following in a select statement that I need to convert to run on SQL Server. Any ideas?

NZ([Merchant].[M_NAME],[Program].[ProgramName])

 

[SQLDenis]

COALESCE([Merchant].[M_NAME],[Program].[ProgramName])


Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[gmmastros]

Lookup IsNull and Coalesce in Books On Line.

Select Coalesce([Merchant].[M_NAME],[Program].[ProgramName])
From Table

Will return [Merchant].[M_NAME] if it is not null. If it is, then Program.ProgramName will be returned.

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[bborissov]

ISNULL([Merchant].[M_NAME],[Program].[ProgramName]) also

Borislav Borissov

 

[LonnieJohnson]

That is a cool function. I have never heard of that until now.

ProDev, MS Access Applications
Visit me at ==>

http://www.prodev.us

May God bless you beyond your imagination!!!