I have a set of documents that have volume and issue numbers
represented as strings (e.g. 1, 10, 2, 23). If I use the following
collation, I get a nice numeric sort without having to pad or
otherwise normalize the data, but performance suffers. Is there an
index I can add that would
I have a set of documents that have volume and issue numbers
represented as strings (e.g. 1, 10, 2, 23). If I use the following
collation, I get a nice numeric sort without having to pad or
otherwise normalize the data, but performance suffers. Is there an
index I can add that would
James,
You're right -- the data is mixed. For example, you might get s2 or
pt2 for an issue or a roman numeral for a volume. The cast fails on
these but the collation based sort seems to treat them as text and
keeps going.
Alan
On 4-Jun-07, at 6:52 PM, James A. Robinson wrote:
I