You need to sign in to do that
Don't have an account?
Deepu2123
Need to query the length of the fied
Hi Devs,
I am facing the issue in Query.Contacts with NPN numbers that are not null and have less than 10 digits
Select Id,Name,NPN__c FROM CONTACT WHERE NPN__c != null AND NPN__c.Length()<10
NPN__C = Text Fied
.
I am facing the issue in Query.Contacts with NPN numbers that are not null and have less than 10 digits
Select Id,Name,NPN__c FROM CONTACT WHERE NPN__c != null AND NPN__c.Length()<10
NPN__C = Text Fied
.
create a new fomrual to get the length as shown below
API Name : NPN__Len__c
IF(ISBLANK(NPN__c ), 0, LEN(TRIM(NPN__c )))
Use this in SOQL
Select Id,Name,NPN__c FROM CONTACT WHERE NPN__c != null AND NPN__Len__c<10
Try the below query:
use 10underscroes to check whether phone contains 10characters or not.
Hope this will be helpful.
Query would be like this:
Select Id,Name,NPN__c FROM CONTACT WHERE NPN__c NOT like '__________%'
Please mark this as best answer if you find it positive.
Thanks
Jolly Birdi