an if clause in a sql query

[Ecniv]

Hey all.
This one is Access, Not SS

I tried with IIF but I guess i worded it wrong. the error is:
Syntax error (missing operator) in query expression '(iif(Instr(ArticleHTML, '<img') > 0,'True','False') as HaveImg)'.
basically the same error when using Case When.

Close, try this:

(iif(Instr(1,[ArticleHTML], '<img') > 0,'True','False') as HaveImg)