On 4/10/07, Mike yearwood <[EMAIL PROTECTED]> wrote:

> You could also do...
>
> lcLength = ALLTRIM(STR(LEN(m.lcSearchString)))
> LOCATE FOR RIGHT(PADL(cAccountNo,20),&lcLength.) = m.lcSearchString

Yep. Only benchmarking with the real app would determine which would
be more efficient in this case. Generally speaking, macro expansion is
slower, but in milliseconds, which really only matters in heavy
looping situations. Otherwise, it's masked by the I/O overhead.

Didn't someone write up a presentation or a white paper on this once?

-- 
Ted Roche
Ted Roche & Associates, LLC
http://www.tedroche.com


_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Reply via email to