I figured I would share an interesting thing I discovered today that appears to be amazingly undocumented.

If you use U2U CAML Query Builder to build your CAML queries it creates queries that look like this when querying against columns of type 'User':

 <property name="QueryOverride" type="string">
      <![CDATA[<Where><Eq><FieldRef Name='Author' /><Value Type='User'>[Me]</Value></Eq></Where>]]>
 </property>

And that query will not work.  It will return zero results.

So queries like this:

<property name="QueryOverride" type="string">
          <![CDATA[<Where><Eq><FieldRef Name="Index_x0020_Number" /><Value Type="Number">7</Value></Eq></Where>]]>
</property>

and this:


<property name="QueryOverride" type="string">
          <![CDATA[<Where><Contains><FieldRef Name="Title" /><Value Type="Text">testapp</Value></Contains></Where>]]>
</property>

will work fine but using the token '[me]' like it is used everywhere else in MOSS will not work.

The solution ends up being this:

<property name="QueryOverride" type="string">
        <![CDATA[<Where><Eq><FieldRef Name='Author'  /><Value Type="User"><UserID /></Value></Eq></Where>]]>
</property>