Why using Decimal in this CAML Query is not returning correct records?

Question

I have the following table:

DoubleNumber
-------------
10.50
44.77
88.90

I am using the following CAML Query:

query.Query = "<Where><Contains><FieldRef Name=\"DoubleNumber\"/><Value Type=\"Decimal\">44</Value></Contains></Where>";

Logically speaking, it should return no records. But, I dont understand why it keeps returning the second record.

Any idea?

Amal Hashim · Accepted Answer · 2015-02-03 03:42:58Z

0

Instead of Contains you should use <Gt> (Greater than) or Lt (Less than).

Contains operator works with String type. Since you are using decimal you should always use arithmetic logic operators.

answered Feb 3, 2015 at 3:42

Amal Hashim

28.4k5 gold badges33 silver badges61 bronze badges

1 Answer 1