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.

Is Salesforce case-sensitive?

ARE SALESFORCE IDS CASE SENSITIVE? Salesforce has two versions of the id for each record. There is a 15-character id that is case sensitive and might have duplicate ids if treated as case insensitive. There is also an 18-character version of the same id which appends 3 more letters to make in case insensitive.

Can we use * in SOQL?

In short, if we are making a SOQL query on a custom object, it will return a list of custom objects. Moving forward, SOQL does not support advanced features of SQL like * and joins. For example, we cannot do “SELECT * ” to perform a selection of all the values.