Logical functions in SQL? 1

[GSMike]

Does anyone know:
In Access there is a logical function you can use in queries called "Switch". Ex:
=Switch(criteria1,value1,criteria2,value2....)
Whichever criteria is deemed true,the value associated with that criteria is returned.
Is there any function in SQL that mimics this functionality? Are there logical functions available in SQL Server in general? Thank you...

 

[jballum]

Take a look at 'Case' in online books.

JB

 

[Cagliostro]

in SQL server is the
where SomeThing in(value1, value2...) John Fill