lundi 2 février 2015

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



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?








0 commentaires:

Enregistrer un commentaire