On Wed, Feb 9, 2011 at 4:49 PM, Richard Kaye <[email protected]> wrote: > It looks like you've got it backwards. The left side of your WHERE clause > should be the field expression and the right side your memvar reference. > > Where UPPER(serno)=m.trcask -----------------
Is there an execution plan that tells you what VFP will do for a script/statement? If you index on UPPER(column) why would you NOT store that value? Why would you expect the engine to Upper() every row to see if the value fits and think that you would not get an impact in the query? -- Stephen Russell Sr. Production Systems Programmer CIMSgts 901.246-0159 cell _______________________________________________ Post Messages to: [email protected] 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.
