Right, it is not case-sensitive when you are dealing with commands, procedures, functions...general syntax. But when you are talking about strings, thankfully, an 's' does not equal an "S".
>no it means Select=SELECT=SELect etc.
>
>Arnon
>
>>
>>Could someone please set me straight. The VFP 5.0a help file states
>>"Neither Visual FoxPro nor BASIC are case-sensitive programming
>languages."
>>Shouldn't that mean that if I do a SELECT * FROM table1 WHERE keyfield =
>>"s422" I would get records where keyfield = "s422" and "S422"? That's not
>>working for me. So...how do I structure an SQL statement so I the
>duplicate
>>records when I do: SELECT keyfield FROM table1 GROUP BY keyfield HAVING
>>COUNT (*)>1?
>>
>>Jeff
>>
>>
Joseph C. Kempel
Systems Analyst/Programmer
JNC