Answer.
The field names used in an object's SOQL select statements are case-insensitive. Therefore, the query: "SELECT id, NAme FROM Account" should be correct.
See AlsoSargable vs Non Sargable QueryThe object names used in SOQL are case-sensitive. Therefore, the query: "SELECT id, Name FROM ACCOUNT" may not be handled correctly.
Despite this, there are several exceptions where the case of SOQL fields is important:
- For Fields Mapping and Data Anonymization, you need to specify fields and object names exactly as they are case-sensitive.
- When listing sObject field(s) in an externalId setting, it is crucial to ensure that the fields are spelled correctly, as this setting is case-sensitive.
Last updated on 18th Apr 2024
