Is there a way to perform string logic on the key field using a subquery or some other method.
IE. If the left 4 characters of the key are ABCD, then include or exclude those from the search. Here is the "laymans" pseudo code for what I'm wanting to do: *:* AND LEFT(KEY, 4) <> 'abcd' Anyone know that one?