Asked by: Timo Villayandre
asked in category: General Last Updated: 8th May, 2020

Is SOQL case sensitive?

Salesforce Object Query Language(SOQL) is case insensitive which means we can write in Uppercase, Lowercase and in both Lower and Uppercase.

Click to see full answer.


Keeping this in consideration, is Salesforce case sensitive?

Salesforce provides you with two versions of Record IDs – a 15 character and an 18 character ID. The case-insensitive ID is identical to the 15-character case-sensitive ID, but with 3 extra characters appended to indicate the casing of each of the original 15 characters.

what is SOQL query in Salesforce? SOQL stands for Salesforce Object Query Language. You can use SOQL to read information stored in your org's database. SOQL is syntactically similar to SQL (Structured Query Language). You can write and execute a SOQL query in Apex code or in the Developer Console's Query Editor.

Similarly, you may ask, how do I use like operator in SOQL?

The LIKE operator is supported for string fields only. The LIKE operator performs a case-insensitive match, unlike the case-sensitive matching in SQL. The LIKE operator in SOQL and SOSL supports escaping of special characters % or _ . Don't use the backslash character in a search except to escape a special character.

How do I create a SOQL query in Salesforce?

To include SOQL queries within your Apex code, wrap the SOQL statement within square brackets and assign the return value to an array of sObjects. For example, the following retrieves all account records with two fields, Name and Phone, and returns an array of Account sObjects.

33 Related Question Answers Found

Are Salesforce IDs sequential?

What is unique ID in Salesforce?

What are the differences between 15 and 18 digit record IDs?


What do the first three characters of a Salesforce record identify?

Where is the contact ID in Salesforce?

What is Salesforce record ID?


What's the maximum batch size in a single trigger execution?

What is limit in SOQL?


What is not like SQL?

What is dynamic SOQL in Salesforce?

Where is SOSL?


What is SAQL?

What is the difference between SOQL and SOSL?