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/html --- _______________________________________________ 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/cag1nny8r3bbhbjtx5+dno4beriaksbxzpab-q4-nzj7yzmc...@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.
