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.

See Also

About Data Types