Asked by: Timo Villayandreasked in category: General Last Updated: 8th May, 2020
Is SOQL case sensitive?
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.