IIf in view

[Pauldohert]

How do I put a derived field into a view iN SQL Server

In access I would have

IIf([field1] = True,"",[Field2])

Or Alertantively can I return a Null instaed of the zero length string.

IIf([field1] = True,Null,[Field2])

Thanks

 

[Pauldohert]

For this particular example I can get way with


LEFT(Field2, LEN(Field2) * ~ Field1) AS Expr1


But only because field1 is yes,no

 

[Kodo]

for the null replacement you can do

ISNULL(FieldName,ReplacementValue)