Where is the error in MS SQL 2008 view?

Question

SQL Server

Good afternoon!
Already tired of digging on the Internet and poking everything at random. I am transferring MS Access queries to MS SQL views.

Part of the view code looks like this:

SELECT ... , IIf([MTR].[Способ выполнения]>2 And [MTR].[Цех]>0,21381,21382) AS Выражение2 FROM MTR;

When creating a view or checking sql syntax, I get an error Incorrect syntax near the construction ">"

Answer 1

SELECT CASE WHEN ([Способ выполнения] > 2) AND ([Цех] > 0) THEN 21381 ELSE 21382 END FROM MTR