contain statement in query

[chungtinhlak]

I'm trying to run a query to have an extra column to say iif([soi] contains nc, then "JOBs is good", "")

I tried using like but it doesn't work.

thanks

[CreganTur]

Is nc a string value you're looking for, or is it another field within the table?

[chungtinhlak]

yes

[CreganTur]

Is nc a string value you're looking for, or is it another field within the table?

"Yes" does not answer this question. Please specify.

[chungtinhlak]

nc is a string value in a column within my table.

[CreganTur]

The first thing that pops out at me is the fact that you do not have nc declared as a string value in your expression. You must wrap strings in quotes (either double or single. It's really a matter of preference; I always use double-quotes out of habit).

The second issue is that Contains is not a valid SQL keyword. However, you could have written that expression as pseudo-code, in which case I'm misreading it.

Does this work?
IIF(soi = "nc", "Job is good", "")