This depends a lot on the terminal, and my advise is to always suround the glob with quotes:
find . -iname "*file*"
zsh will cry that nothing matches the glob if you don't. bash will expand it if something matches, or pass it as-is to the client if something does - which will give you unexpected results.