14

I am looking for a way to query all leads which have the length of city__c > 20 characters in SOQL.

I cant seem to find anything like a length() in SOQL. Any workarounds? Or am i missing something obvious on the documentation

15

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 ... From ...  Where FormulaField___c > 20
17
SELECT Id FROM User WHERE (NOT Username LIKE '___')

The above SOQL query will return all user rows where the username is not 3 characters.

SELECT Id FROM User WHERE Username LIKE '______'

The above SOQL query will return all user rows where the username is 5 characters.

  • I was surprised to see the positive scenario work, but the negative results in a malformed query (not like). Are you sure that works ? – Samuel De Rycke Oct 14 '14 at 16:10
  • Thank you for this information, Mark. FYI I had to put parentheses around the negative to make it work: (NOT Username Like '___') – Rob Alexander Nov 13 '14 at 15:56
  • 3
    Nice find! This definitely works. – Willem Mulder Nov 26 '14 at 10:40

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.