I have a select statement which USED to be optimized, but the client added a filter to the index expression. How do I modify my SELECT to accommodate the filter?
The index is UPPER(Job.External) and the filter is .NOT. EMPTY(External)
My old select is something like:
SELECT blah blah blah FROM LinkJob INNER JOIN External ;
ON LinkJob.External = UPPER(Job.External) ;
blah blah blah
INTO CURSOR TQuery
TIA
Kogo Michael Hogan
"Pinky, are you pondering what I'm pondering?"
I think so Brain, but "Snowball for Windows"?
Ideate Web Site