IIF IN A VIEW QUESTION

[robmoors]

Can I put a IIF statement in a VIEW like I can in Access query? If I can, can you give me an example, if not what do I use to replace the IIF statement.

Thank you in advance.

 

[ldandy]

You cannot use IIF in SQL Server, but you can use the CASE statement.

 

[BogdanRo]

You may use "CASE WHEN ... ".
For example if you have a table
Product( ID , Name , Stock )
where id = primary key

SELECT ID, Name , Stock , Info = CASE
WHEN Stock >= 1000 THEN 'OK'
ELSE 'not ok'
FROM Product (SQL Server version)

is equivalent with

SELECT ID, Name, Stock, IIF( Stock >= 1000 , 'ok' , 'not ok' )
FROM Product

 

[BogdanRo]

SELECT ID, Name, Stock, IIF( Stock >= 1000 , "ok" , "not ok" )
FROM Product
in MS Access