How do you write iif isnull in SQL View?

[kayek]

The following is an Example Access Query I want to put make into an SQL View. The iif(isnull) is not working. Need help on writing the SQL Statement.

SELECT Column_A, Column_B, (iif(isnull(Column_A),0,Column_A))-(iif(isnull(Column_B),0,Column_B)) as Column_C From Table1

 

[gmmastros]

If I understand properly, then this should do the trick for you.

[COLOR=blue]SELECT[/color] Column_A, 
       Column_B, 
       [COLOR=#FF00FF]isnull[/color](Column_A, 0)-[COLOR=#FF00FF]isnull[/color](Column_B, 0) [COLOR=blue]as[/color] Column_C 
[COLOR=blue]From[/color]   Table1

With SQL Server, IsNull Is a function that accepts 2 parameters and returns a value. If the first parameter is null, then the second parameter is returned.

-George

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

 

[kayek]

That worked. Thanks!!!