Formula to Find Whole Word, Not Part of A Word

[kc27]

If I use a formula like {file_info.desc} like "*ken*", it returns results that include words like kennedy or kent.

How do I modify the formula to return values that just include the whole word "ken", and exclude values that have words that also contain those those three letters?

Thanks for any ideas on this.

 

[AndyMc]

instr({file_info.desc},"ken ")

If this returns a value > 0 then it found ken with a space after it.

you could also test for
instr({file_info.desc}," ken") or
instr({file_info.desc}," ken ")

 

[kc27]

Thank you! Adding the space pulled the records I needed.