Query for records which have the city length > 20

Question

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

Answer 1

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

Answer 2

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.