Try quoting it as "'A12'..." instead. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Allen Egerton Sent: 11 March 2005 20:08 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Indexing issue
From: "Dan Knutson" <[EMAIL PROTECTED]> Sent: Friday, March 11, 2005 2:23 PM Subject: [U2] Indexing issue > I have a file that has thousands of keys that start with an A. There is > an index on the key. When I try and do a search for any items that start > with say A12 and I type in A12... the search does not return what I > expect and takes a long time because Unidata thinks it is doing a > Alphanumeric search. > Is there a way to get the results I expect? If the primary key is indexed, that's pretty much a waste of time. Indexing PART of the primary key on the other hand would be useful. You might consider creating an I-Type dictionary item that's @ID[1,3], and then indexing that field. That would work rather quickly. ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/