I think Rod already touched on it. A combination of CHANGE, FIELD, and DCOUNT will tell you the position that a particular string falls in a dynamic array; without having to drop out to a SUBR. If that is all you need -- if you don't require the logical results from the bi-conditional associated with the standard LOCATE syntax, then this will get you a result.
CHANGE the character string to something unique like CHAR(189). FIELD of CHAR(189), taking the first field and then DCOUNT that string. If you need a positional value of sub-values within multi-values, that of course requires more fielding and dcounting. Regards, Trey -------------- Original message ---------------------- From: "Marc Harbeson" <[EMAIL PROTECTED]> > Yea - but if ANYONE knows how to avoid the SUBR it would be Trey Miller... > > <snicker> > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Mark Eastwood > Sent: Thursday, August 09, 2007 3:18 PM > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] How to use LOCATE in an I Descriptor > > My first thought would be to create an I-descriptor that calls a basic > subroutine (SUBR) to do the LOCATE and return value. > > Mark > > > -----Original Message----- > > Subject: [U2] How to use LOCATE in an I Descriptor > > I have someone asking me how to use a LOCATE statement in an I > Descriptor. I have never done that and would not know if it is > possible, or what the syntax is. Does anyone know if you can do this, > and what the syntax would be to use the resultant location? > ------- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ > > > No virus found in this incoming message. > Checked by AVG Free Edition. > Version: 7.5.476 / Virus Database: 269.11.8/940 - Release Date: 8/6/2007 4:53 > PM > > > No virus found in this outgoing message. > Checked by AVG Free Edition. > Version: 7.5.476 / Virus Database: 269.11.8/940 - Release Date: 8/6/2007 4:53 > PM > ------- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
