>>>>>>
>>>>>>Right, I forgot that the length was irrelevant, as long as lname and fname are trimmed.
>>>>>
>>>>>If it is not leading spaces, then no trimming is needed. Trailing spaces are unimportant.
>>>>
>>>>For DBF's they are.
>>>
>>>No they are not. We are talking about SQL, no?
>>
>>Yes, I meant that trailing spaces must be trimmed when you use SQL syntax against DBFs. (You made me unsure, so I just tested it).
>
>I am not sure what you have tested. When using SQL, with == operator, trailing spaces are not important. I have posted demo code here on UT many many years ago and also you can find the demo codes on Stackoverflow VFP guide (posted there too).

Select * from (Home(0)+'foxcode.dbf') where abbrev = 'C ' && No record
Select * from (Home(0)+'foxcode.dbf') where abbrev = 'C' && Many records