Case Sensitivity
Welcome to our Knowledge Base
Documentation | Blog | Demos | Support
< All Topics
Print
Case Sensitivity
5 out of 5 stars
1 rating
5 Stars | 100% | |
4 Stars | 0% | |
3 Stars | 0% | |
2 Stars | 0% | |
1 Stars | 0% |
Except in certain limited instances (e.g., security passwords, values held in objects of data type CHAR and VARCHAR), the software is case insensitive. Insensitivity to case means that the software makes no distinction between uppercase and lowercase letters in any part of a statement. For example, the following statements are identical, provided LastName is not a CHAR or VARCHAR field:
list all employees where lastname = ‘smith’
LIST ALL EMPLOYEES WHERE LASTNAME = ‘SMITH’
lIsT aLl EmPlOyEeS wHeRe LaStNaMe = ‘SmItH’
list all employees where LastName = ‘Smith’
Normally, in a statement, you can use the combination of uppercase and lowercase letters that makes the statement most readable.
Updated
ByJason Lee
Was this article helpful?
5 out of 5 stars
1 rating
5 Stars | 100% | |
4 Stars | 0% | |
3 Stars | 0% | |
2 Stars | 0% | |
1 Stars | 0% |
5