function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
DipeshDipesh 

Number(16,2) not allow to Search more than 9 digit in where clause

I have one Custom Object Named 'Purchase_Order__c' with  field ' Total_Amount__c' - Data Type  Number(16,2)

 

When i query : select id from Purchase_Order__c Where Total_Amount__c= 9999999911 

 

Its giving me error

 

MALFORMED_QUERY:
Purchase_Order__c Where Total_Amount__c= 9999999911
^
ERROR at Row:1:Column:57
For input string: "9999999911"

 

I am taking Number(16,2) , so It should allow me in where clause upto 16 digit numbers. but its throwing me error.

If i remove one digit then its work fine.

 

Please Help me ASAP.

 

Thanks,

Dipesh 

 

Best Answer chosen by Admin (Salesforce Developers) 
AshishyadavAshishyadav
try giving

select id from Purchase_Order__c Where Total_Amount__c= 9999999911.00