[dba-SQLServer]Iif equivalent

Look up CASE in BOL.





>From: "Susan Harkins" <harkins at iglou.com>
>Reply-To: dba-sqlserver at databaseadvisors.com
>To: "SQLList" <dba-SQLServer at databaseadvisors.com>
>Subject: [dba-SQLServer]Iif equivalent
>Date: Sat, 3 May 2003 16:27:04 -0400
>
>I'm looking for an equivalent to Access' Iif() function -- can't seem to
>find anything -- is there one? In Access, you can use a quick expression in
>the form
>
>Iif(field=whatever,value,value)
>
>in a query to determine a field's content -- can you do the same in SQL
>Server?
>
>Susan H.
>
>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com
>


_________________________________________________________________
Add photos to your e-mail with MSN 8. Get 2 months FREE*.  
http://join.msn.com/?page=features/featuredemail