>>>>>>>
>>>>>>>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

So what? I said using == operator.