On 7/16/2014 1:40 PM, Sytze de Boer 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?


how about index on str(pcode, 5, 0) + str(pcode2, 7, 0) + str(pcode3, 9, 0) [to myindex.idx or tag mytag]

HTH

--
Jeff

Jeff Johnson
j...@san-dc.com
SanDC, Inc.
623-582-0323
Fax 623-869-0675

http://www.san-dc.com

_______________________________________________
Post Messages to: ProFox@leafe.com
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/53c6e4f5.3090...@san-dc.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.

Reply via email to