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)

Ashishyadav
try giving

select id from Purchase_Order__c Where Total_Amount__c= 9999999911.00

Need an account? Sign Up

Have an account? Sign In