>I feel stupid asking this but I have to. I know what ALLTRIM() is. I know what TRIM() is as well as LTRIM(),RTRIM(), and the various PAD functions.
>
>What is ALLTRIM(), TRIM
>
>Do you mean ALLTRIM(TRIM())?
>I have many times use LTRIM(TRIM(firstname) + ' ') .... to add a trailing blank to the trimmed first name only if the firstname is not empty.
>
Sorry, Dore. I just meant any trimming of any kind. My point is that VFP folks are TRIMming for lookup when I believe trimming is for display and should be avoided in lookup/matching/SQL unless you want partial matches for some reason.
"Smithson" = "Smith", etc.