>Shouldn't that mean that if I do a SELECT * FROM table1 WHERE keyfield = "s422" I would get records where keyfield = "s422" and "S422"?

Case sensitivity in a language pertains to entity names such as variables. In FoxPro, startdate and StartDate are the same variable, but in C, for example, they are not. This rule does not apply to strings as your above message illustrates. Also, language key words are not affected by case sensitivity. Whether you type select, SELECT, printf(), or PRINTF(), the compiler doesn't care.