How to Find Data in Part of Cell

[doyle60]

I have a query with a field called Fabric. I want to create a column
in the query that returns Yes if any part of the Fabric field has the
letters "cot" in it.

So I naturally thought to put asterics around the word ("*Cot*") and
writing this:

Cot: IIf(Fabric = "*Cot*","Yes")

But it doesn't work and returns nothing for all.

How do I do this correctly?

Thanks,

Matt

 

[bob]

cot:iif([fabric] is like "*" & "cot" & "*","Yes", "")

Bob

 

[fredg]

I have a query with a field called Fabric. I want to create a column
in the query that returns Yes if any part of the Fabric field has the
letters "cot" in it.

So I naturally thought to put asterics around the word ("*Cot*") and
writing this:

Cot: IIf(Fabric = "*Cot*","Yes")

But it doesn't work and returns nothing for all.

How do I do this correctly?

Thanks,

Matt

Cot:IIf(Instr([FieldName],"Cot")>0,"Yes","No")

 

[doyle60]

Thanks Bob. But it didn't work. After five minutes of playing around
with it, I was able to figure out that "Like" was needed and not "Is
Like". So this works:

Cot: IIf([Fabric] Like "*" & "cot" & "*","Yes","")

Thanks,

Matt