Unable to find matches for a multi select box custom field on contacts advanced searc

[seismicmike]

Added a custom field to the contacts, edit, view and advanced search pages. It's a multiple select box that would allow the user to be assigned more than one value. It works find for adding/editing the values, but I'm having trouble finding matches when I search.

If I select one item, it'll match anyone who has that one item (and only that one item) in their field. If I select multiple, it'll match anyone who has one of those items (and only one of those items) in the field.

For example. Let's say the field is "color" and the options are "blue", "green", "red", "purple", and "orange". And let's say I have Bob, Joe and Steve in the system:

Name                       Color
Bob                        blue
Joe                        green
Steve                      blue, green

A search for blue will match Bob. A search for green will match Joe. A search for blue and green will match Bob and Joe. But NONE of them will match Steve. How do I match Steve????

[seismicmike]

bump......

[seismicmike]

bump......