The best answers are voted up and rise to the top, Not the answer you're looking for? On whose turn does the fright from a terror dive end? If you are curious then refer Notes on Changing Custom Field Types. Want to grab a Salesforce Admin job? To subscribe to this RSS feed, copy and paste this URL into your RSS reader. Generating points along line with specifying the origin of point generation in QGIS. How about saving the world? NumberField__c < 1000 The correct way to check if the length of a numeric text field is less than 4: LEN (NumericTextField__c) < 4 3. Click here to. The help for "Using Rich Text Area Fields" (https://na5.salesforce.com/help/doc/en/fields_using_rich_text_area.htm) says: Does this mean that a single record can have at most 1.6 million characters in rich/long text fiels, or that all the rich/long data for an entire object can't exceed 1.6 million? What is Data Science? What are the parameters for the Salesforce WebServiceCallout.invoke method? To learn more, see our tips on writing great answers. You need to create a new formula filed of type NUMBER and insert a simple formula to it that calculates a length of the string: LEN (Street__c) LEN Formula Then you can query on this field: Select . Notes: Leading blank spaces and zeros are omitted. If the value in text is longer than pad_string, text is truncated to the size of padded_length. Has the Melford Hall manuscript poem "Whoso terms love a fire" been attributed to any poetDonne, Roe, or other? You have 1,584,632 additional characters to allocate to this field. Next on the Add to layout page click the Save & New button. My understanding of the documentation, and the answers to other similar questions, .getLength() should be the way to go (and return 10 for that field). Order Name: data value too large: How to get few words from the long string in non sequential order, SOSL: How to programmatically work out what field a search string is found in, System.DmlException: Insert failed. The following formula should work for a number field: The following should work for numeric text: The above formula for numeric text results in: 1) Try converting number to a text using TEXT() function and find the length using LEN(). The limit is imposed on the definition of the object itself (while creating the object definition) even if there are no records in it at all you'll still it this limit if you add to many long fields. Create a long or rich text field, in the next page, on the Length input, the Salesforce will tell you, like this, You are currently using 53,768 out of 1,638,400 characters on this object.