At 05:26 + 2004/02/06, Marco Manyevere wrote:
Short and easy to follow but N is not always numeric.
You can add a regular old variable to hold all of the prefixes, use a
LOCATE() to find the field number of the prefix and then use that to
access the array N. Going through all this, might
Hi All,
I have a file with IDs like this:
1.2, 1.2 1.3, 2.1, 2.2, 2.3, 2.4, 3.1, 4.1, 5.1, 5.2, ...
Each ID is N.X where X is a numeric secondary ID number from 1 going upwardsand N is the primary ID number which may or may not be numeric.Different primary IDs have a different number of
] On Behalf Of Marco
ManyevereSent: 04 February 2004 08:20To:
[EMAIL PROTECTED]Subject: Help wanted creating an efficient SELECT
statement
Hi All,
I have a file with IDs like this:
1.2, 1.2 1.3, 2.1, 2.2, 2.3, 2.4, 3.1, 4.1, 5.1, 5.2, ...
Each ID is N.X where X is a numeric secondary ID numbe
lto:[EMAIL PROTECTED] On Behalf Of Marco
ManyevereSent: 04 February 2004 08:20To:
[EMAIL PROTECTED]Subject: Help wanted creating an efficient SELECT
statement
Hi All,
I have a file with IDs like this:
1.2, 1.2 1.3, 2.1, 2.2, 2.3, 2.4, 3.1, 4.1, 5.1, 5.2, ...
Each ID is N.X where X is a numeric secon