Return to Question

added 7 characters in body; edited tags; edited title

Source Link

edited Sep 12, 2016 at 22:54

151.4k
38
247
431

Upper/Lowercase Sensitiveness in SOSL Make SOQL Case-Insensitive?

I have this query:

List accounts1 = [SELECT Id, PersonContactId, PersonEmail, FirstName, LastName, net_Id__pc FROM Account where net_Id__pc = pFederationID]

List<id> accounts1 = [SELECT Id, PersonContactId, PersonEmail, FirstName, LastName, net_Id__pc FROM Account
                         where net_Id__pc = pFederationID]

I need the constraint net_Id__pc = pFederationID tonet_Id__pc = pFederationID to be case non sensitiveinsensitive. I meanFor example, if net_Id__pc = 'jOeDoe' and pFederationID = 'joedoe'net_Id__pc = 'jOeDoe' and pFederationID = 'joedoe' then they should be considered equal. How can this be done?

Upper/Lowercase Sensitiveness in SOSL

I have this query:

List accounts1 = [SELECT Id, PersonContactId, PersonEmail, FirstName, LastName, net_Id__pc FROM Account where net_Id__pc = pFederationID]

I need the constraint net_Id__pc = pFederationID to be case non sensitive. I mean, if net_Id__pc = 'jOeDoe' and pFederationID = 'joedoe' then they should be considered equal. How can this be done?

Make SOQL Case-Insensitive?

I have this query:

List<id> accounts1 = [SELECT Id, PersonContactId, PersonEmail, FirstName, LastName, net_Id__pc FROM Account
                         where net_Id__pc = pFederationID]

I need the constraint net_Id__pc = pFederationID to be case insensitive. For example, if net_Id__pc = 'jOeDoe' and pFederationID = 'joedoe' then they should be considered equal. How can this be done?

Source Link

asked Sep 12, 2016 at 22:40

Jose

Upper/Lowercase Sensitiveness in SOSL

I have this query:

List accounts1 = [SELECT Id, PersonContactId, PersonEmail, FirstName, LastName, net_Id__pc FROM Account where net_Id__pc = pFederationID]

I need the constraint net_Id__pc = pFederationID to be case non sensitive. I mean, if net_Id__pc = 'jOeDoe' and pFederationID = 'joedoe' then they should be considered equal. How can this be done?

soql