CAML Query for lookup field with multi values

Question

What is the caml query for a Lookup field with multi values?

So far, I am using the following without success (it just throws an error). My Lookup column is:

Lookup
-------
2;3
2
3;4

<Contains><FieldRef Name="LookupColumn"/><Value Type="LookupMulti">2</Value></Contains>

What is wrong with that query??

Answer 1

SPQuery oQuery = new SPQuery();
oQuery.Query = "<Where><Eq><FieldRef Name=\"LookupColumn\" LookupId=\"TRUE\"/><Value Type=\"LookupMulti\">2</Value></Eq></Where>";