Use BINTOC(). E.
On Wednesday, July 16, 2014 6:40 PM, "[email protected]" <[email protected]> wrote: > > >I'm gonna make a wager and say "NO", and I know that's a large risky >wager seeing how it's Ted's comment (and we all know he's an ace!). > >Why not the compound index as you (Jeff) described? I would have said >the same thing. > >--Mike > > >On 2014-07-16 17:23, Jeff Johnson wrote: >> Ted: So these indexes are created so that when you run that select >> statement it will put them in order? >> >> Interesting. >> >> On 7/16/2014 1:56 PM, Ted Roche wrote: >>> Sytze: >>> >>> I've been surprised to find everyone works with a "large amount of >>> data" >>> but for some of us, that's thirty thousand records and for others it >>> is >>> thirty million. >>> >>> >>> INDEX ON pcode TAG pcode >>> INDEX ON pcode2 TAG pcode2 >>> INDEX ON pcode3 TAG pcode3 >>> INDEX ON DELETED() TAG DELETED >>> >>> >>> >>> On Wed, Jul 16, 2014 at 4:40 PM, Sytze de Boer <[email protected]> >>> wrote: >>> >>>> After yesterday, with heart in mouth, I ask the following >>>> >>>> I have a table with large amount of data >>>> It contains Master contract, sub contract, sub-sub contract >>>> pcode N(5) >>>> pcode2 N(7) >>>> pcode3 N(9) >>>> >>>> Example >>>> 3770 >>>> 3770, 377001 >>>> 3770, 377001, 37700101 >>>> 3770, 377001, 37700102 >>>> 3770, 377002 >>>> 3770, 377002, 37700201 >>>> 3770, 377002, 37700202 >>>> >>>> When I do a select statement, I seem to get them in correct order >>>> with >>>> select * from contract order by pcode,pcode2,pcode3 etc >>>> >>>> But if I want to create an index, I lose my head. >>>> >>>> Any pointers? >>>> >>>> -- >>>> Kind regards, >>>> Sytze de Boer >>>> Kiss Software >>>> >>>> >>>> --- StripMime Report -- processed MIME parts --- >>>> multipart/alternative >>>> text/plain (text body -- kept) >>>> text/[excessive quoting removed by server] _______________________________________________ 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/[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.
