<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.2963" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=686131000-14102006><FONT face=Arial size=2>in RT 3.4.5 and
3.6.1, should this really return anything where "somefield" is
multi-valued?</FONT></SPAN></DIV>
<DIV><SPAN class=686131000-14102006><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=686131000-14102006>
<DIV dir=ltr align=left><SPAN class=030225223-13102006><FONT face=Arial><FONT
color=#0000ff><FONT size=2>CF<SPAN
class=686131000-14102006>.{somefield</SPAN><SPAN
class=686131000-14102006>}</SPAN> <SPAN class=686131000-14102006>!=
</SPAN><SPAN class=686131000-14102006>'X' </SPAN>AND CF<SPAN
class=686131000-14102006>.{somefield}</SPAN> <SPAN
class=686131000-14102006>= </SPAN><SPAN
class=686131000-14102006>'X'</SPAN></FONT></FONT></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=030225223-13102006><FONT face=Arial><FONT
color=#0000ff><FONT size=2><SPAN
class=686131000-14102006></SPAN></FONT></FONT></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=030225223-13102006><FONT face=Arial><FONT
color=#0000ff><FONT size=2><SPAN class=686131000-14102006>For me, it does. It
seems to be comparing the string with every value for the field and therefore
matches just about everything. Is there a way, for example, of saying "show me
everything which has no value matching
'X'</SPAN></FONT></FONT></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=030225223-13102006><FONT face=Arial><FONT
color=#0000ff><FONT size=2><SPAN
class=686131000-14102006></SPAN></FONT></FONT></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=030225223-13102006><FONT face=Arial><FONT
color=#0000ff><FONT size=2><SPAN class=686131000-14102006>CF.{somfield} !=
'X'</SPAN></FONT></FONT></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=030225223-13102006><FONT face=Arial><FONT
color=#0000ff><FONT size=2><SPAN
class=686131000-14102006></SPAN></FONT></FONT></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=030225223-13102006><FONT face=Arial><FONT
color=#0000ff><FONT size=2><SPAN class=686131000-14102006>seems to be saying
"show me everything which has *any* value which doesn't match
'X'</SPAN></FONT></FONT></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=030225223-13102006><FONT face=Arial><FONT
color=#0000ff><FONT size=2><SPAN
class=686131000-14102006></SPAN></FONT></FONT></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=030225223-13102006><FONT face=Arial><FONT
color=#0000ff><FONT size=2><SPAN
class=686131000-14102006>PK</SPAN></FONT></FONT></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=030225223-13102006><FONT face=Arial
color=#0000ff size=2><SPAN
class=686131000-14102006></SPAN></FONT></SPAN> </DIV></SPAN></DIV>
<DIV> </DIV>
<DIV align=left><FONT face=Arial size=2>--</FONT></DIV>
<DIV align=left><FONT face=Arial size=2>Philip Kime</FONT></DIV>
<DIV align=left><FONT face=Arial size=2>NOPS Systems Architect</FONT></DIV>
<DIV align=left><FONT face=Arial size=2>310 401 0407</FONT></DIV>
<DIV> </DIV></BODY></HTML>