Are there any tricks to using the "contains" option in triggers? I can get my triggers to fire when using =; but contains will not produce any results?

- is it case sensitive?
- can wildcards be used; or simply partial word?