Example of MS Access SQL IIF to T-SQL Given the syntax rules shown below


Access: IF(Condition, ReturnIfTrue, ReturnIfValue)
T-SQL: CASE WHEN Condition THEN ReturnIfTrue ELSE ReturnIfFalse END


What would the below be formatted to T-SQL be?

(((IIf(IsNull(Production!Product_Title) Or Production!Product_Title Like "Process*",
"Not Started", "Started"))="Not Started") And ((Person.Type) Is Not Null))
Seems you don't have to use IIF or CASE 

(
    (
    Production.Product_Title IS NULL
    OR Production.Product_Title Like 'Process%'
    )
AND Person.Type IS NOT NULL
)


FYI, Transact-SQL has IIF function starting with 2012.

UPD

If you had to return some value:

SELECT
    CASE WHEN 
        Production.Product_Title IS NULL
        OR Production.Product_Title Like 'Process%'
    THEN 'Not Started'
    ELSE 'Started'
    END AS [ProductState]
FROM YourTable