On Wed, Apr 16, 2014 at 11:37 PM, Andrew Stirling <[email protected]> wrote: > Thanks Peter & All > Got it to work with a ALLTRIM: > WHERE NOT (( ALLTRIM(compno)$mystring ) )
I suppose compno is a column in a table. Does it have an index? alltrim(compno) would break Rushmore optimization, making the index not usable. How about putting the values you wanna exclude in a cursor and then do something like this: select * from source_table ; where compno not in ( ; select compno from exclude_table ; ) -- .~. Might, Courage, Vision. SINCERITY! / v \ 64-bit Ubuntu 9.10 (Linux kernel 2.6.39.3) /( _ )\ http://sites.google.com/site/changmw ^ ^ May the Force and farces be with you! _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CAGv=MJA=fs+5bX3G5+_As9ot=xwyk_fydks0etwht+oeepn...@mail.gmail.com ** 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.
