Re: Testing tells the tale (SYS 3054) -- "BETWEEN(a, b, c)" equivalent to "a BETWEEN b and c"

On 2018-03-19 18:29, Bill Anderson wrote:

Mike,

I believe ALLTRIM()s in SQL doesn't "defeat" optimization, it's just that you can't have ragged (meaning, varying length) indexes in VFP.

A tag on ALLTRIM(field) is padded out to the full length of the field.

Bill Anderson

Hi Bill!

But it really doesn't do anything for you, right? I mean, VFP works best when it's used for it's fixed-width strengths, right? (Keep in mind, I haven't chosen to use VFP backends since 2004!)

--Mike