Query in SQL

carnation
10-14-2005, 03:32 AM
Hi all,

In Access I use the query
"Select IIf([ADDV].[MA] Is Not Null,Count([ngay]),0) AS NC from ADDV ... " Now I want to create a query like this in SQL Server but I don't knnow the function similar to "IIf" in SQL Server? PLease help.

Thanks a lot.

Shurik12
10-14-2005, 05:50 AM
Hi,

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ca-co_5t9v.asp

Shurik

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum