[SixthSense]

[ QUOTE ]
"Filter expression incorrectly terminated"

when i change tablename to table.

[/ QUOTE ]

This exact string below works for me:

not upper(table) like '%[CAP]%'

Note the parenthesis, tick marks, brackets, and percent signs must all be correct.

One more thing, this goes into the "Filter Table" menu, CTRL-R