Using IF logic in a calculated field

[hydroparadise via AccessMonster.com]

Hey guys! In the midst of developing in SQL 2005 with Access as FE. In Jet,
you can use an inline 'if' function to be used in a calculated fields in a
query (ex. IIf(expr,true,false)). I understand that T-SQL has something like
CASE that supposed to do logic testing but not sure if this is adequate for
calculated fields in SQL Server's views. The examples I've seen for CASE
have all been used in stroed procedures, but unfortunately stored procedures
dont allow for updating a recordset in a datasheet view in Access (that I
know of) Does T-SQL have something similar to Jet's IIf function, or am I
better off making a user defined funtion that acts like Jet's IIf. Btw, not
sure if IIf belongs to jet or vba. Thanks!

 

[Douglas J. Steele]

You can use the Case statement in SQL statements.
http://msdn.microsoft.com/en-us/library/ms181765.aspx has some examples.

 

[hydroparadise via AccessMonster.com]

You can use the Case statement in SQL statements.
http://msdn.microsoft.com/en-us/library/ms181765.aspx has some examples.

Hey guys! In the midst of developing in SQL 2005 with Access as FE. In
Jet,

[quoted text clipped - 11 lines]

not
sure if IIf belongs to jet or vba. Thanks!

These examples much better suites what I was looking for. Looks like CASE is
the answer to this case. Thanks!