Hello

I have problem with Query on SQL Server DB.
I want to show field with condition, in Access I wrote it that way:

SELECT iif (condition, field1, field2), field3 FROM Table1

I try it that way but SQL Server dont recognize 'iif' function.

Is any body know how do i do it in SQL Server ? (without using Store Procedure).

Thanks for any help.