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

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


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.





Best Answer chosen by Admin (Salesforce Developers) 
try giving

select id from Purchase_Order__c Where Total_Amount__c= 9999999911.00