Как заменить iif от Access в MsSQLServer

Если в Access было :
SELECT "Клиенты".Id FROM "Клиенты"
WHERE iif("Клиенты".Id=1,1,0)="Клиенты"."Инн"

То в MsSQLServer2000:
SELECT "Клиенты".Id FROM "Клиенты"
WHERE CASE WHEN [Клиенты].Id=1 THEN [Клиенты].[Инн]=1 ELSE [Клиенты].[Инн]=0 END

не проходит

Как правильно ?

А почему не проходит :
SELECT "Клиенты".Id FROM "Клиенты"
WHERE CASE WHEN [Клиенты].Id=1 THEN 1=0 ELSE 0=0 END

Ну спасибо,

а Ваш

SELECT "Клиенты".Id FROM "Клиенты"
WHERE CASE WHEN [Клиенты].Id=1 THEN 1 ELSE 0 END

почему не проходит ?

Вообще , как я понял в MsSQL boolean нет , и как удобнее тогда работать с логическими выражениями ?

Да вот пока непонятно - есть или нет :
С одной стороны типа данных такого нет
С другой стороны выражение может быть booolean типа

Expression Results
For a simple expression built of a single constant, variable, scalar function, or column name, the data type, collation, precision, scale, and value of the expression is the data type, collation, precision, scale, and value of the referenced element.

When two expressions are combined using comparison or logical operators, the resulting data type is Boolean and the value is one of three values: TRUE, FALSE, or UNKNOWN. For more information about Boolean data types, see Operators.

When two expressions are combined using arithmetic, bitwise, or string operators, the operator determines the resulting data type.

Complex expressions made up of many symbols and operators evaluate to a single-valued result. The data type, collation, precision, and value of the resulting expression is determined by combining the component expressions, two at a time, until a final result is reached. The sequence in which the expressions are combined is defined by the precedence of the operators in the expression.

С третьей стороны CASE, являясь функцией, возвращает результат :

Syntax
Simple CASE function:

CASE input_expression
WHEN when_expression THEN result_expression
[ ...n ]
[
ELSE else_result_expression
]
END

Searched CASE function:

CASE
WHEN Boolean_expression THEN result_expression
[ ...n ]
[
ELSE else_result_expression
]
END

Result Types

Returns the highest precedence type from the set of types in result_expressions and the optional else_result_expression. For more information, see Data Type Precedence.

Result Values

Simple CASE function:
Evaluates input_expression, and then, in the order specified, evaluates input_expression = when_expression for each WHEN clause.


Returns the result_expression of the first (input_expression = when_expression) that evaluates to TRUE.


If no input_expression = when_expression evaluates to TRUE, SQL Server returns the else_result_expression if an ELSE clause is specified, or a NULL value if no ELSE clause is specified.
Searched CASE function:
Evaluates, in the order specified, Boolean_expression for each WHEN clause.


Returns result_expression of the first Boolean_expression that evaluates to TRUE.


If no Boolean_expression evaluates to TRUE, SQL Server returns the else_result_expression if an ELSE clause is specified, or a NULL value if no ELSE clause is specified.

Ну и почему нельзя оцененное CASE как boolean выражение использовать в Where условии
????????