You can use an EVAL or an i-descriptor. For example, assuming your field is the ID, then EVAL "@ID[2]" will give you the year, and EVAL "FIELD(@ID, '*', 4, 1)" will give you the route. (or you could use field(5) for the year :-)
Cheers, Wol -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 06 June 2007 10:42 To: [EMAIL PROTECTED] Subject: [U2] Help in creating Retrieve statement for a multivalue field Thank you all for the help. BY-EXP did the work. I need another help to sort the data by one or multiple characters in a field. 01*GAN100*GAN100*WS09*07-In this filed how do I query the last two characters like "07" (year) or "WS09" (Route)? Thanks again. Krish ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
