List Manager Tomfoolery

I've been trying to add a field (from a view I created) to T_KEYWORD so that it may be used as a criterion in List Manager.  So far so good it would seem.  However, when I choose it from the left pane and drag it over to the right, I am only allowed to use "In" instead of the more logical "Like", or even "=" since it is a string and not an integer.  The really odd thing is that under the value column, the drop down shows the appropriate pre-designated values as set up in T_KEYWORD through System Tables.  But, when you choose one and look in the bottom pane by clicking "Display Query", you get the following string:

 AND f.perf_code in  ('if(inactive=''Y'', RGB(100,100,100),RGB(0,0,0))') 

This appears to be the code that tells Tessitura how to display inactive values.  The question is why on Earth would it do that rather than give me a syntax error or something?

The ultimate question of course is:  What am I doing wrong?

Any ideas?  Thank you in advance, Tessiturians.

BONUS ACTIVE TRIVIA:  The only part of the human body that has no blood supply is the cornea in the eye.  It takes in oxygen directly from the air.