Did someone say awhile back that the use of the FoxPro BETWEEN function in an SQL query in code would NOT take advantage of Rushmore optimization? I've seen some SQLs in our code that use BETWEEN(a,b,c) and it would be easy to change out to ANSI-SQL format (WHERE nArg BETWEEN nMin and nMax), but don't want to waste my time if it's a moot point. There's an index on nArg. I could add code to use the SYS(3054,x) but was hoping for someone's quick(er) answer.
tia! --Mike _______________________________________________ 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.
