Stuart, Could also use :-
SELECT DISTINCT CODE TO SLIST 0 FROM LOOKUP.TABLE_CODE; providing CODE is defined as multi-valued hth Andy -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Boydell, Stuart Sent: 23 January 2008 06:57 To: u2-users@listserver.u2ug.org Subject: [U2] [UV] Selection help I have a table which contains an MV list of codes. What I want to do is get a unique list of codes in the table for a lookup list... Table XYZ @ID = XYZ LINE = 1]2]3]4]5]6]7... CODE = AAA]BBB]BBB]CCC]AAA]AAA]BBB... The list I'd like returned is: AAA]BBB]CCC... The semantic I think I'd like is: SELECT LOOKUP.TABLE "XYZ" SAVING UNIQUE CODE However, this doesn't work. Is there a simple select statement to do this I'm overlooking? Cheers, Stuart ********************************************************************** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this communication in error, please reply to this e-mail to notify the sender of its incorrect delivery and then delete it and your reply. It is your responsibility to check this email and any attachments for viruses and defects before opening or sending them on. Spotless collects information about you to provide and market our services. For information about use, disclosure and access, see our privacy policy at http://www.spotless.com.au Please consider our environment before printing this email. ********************************************************************** ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ----------------------------------------- ********************************************* The contents of this e-mail are subject to contract in all cases and William Hill PLC, its subsidiaries or affiliates make no contractual commitment save where confirmed by hard copy. The contents of this e-mail do not necessarily represent the views of William Hill PLC, its subsidiaries or affiliates. We accept no liability, including liability for negligence, in respect of any statement in this e-mail. This e-mail and any files transmitted with it are confidential, may be subject to legal privilege and intended solely for the use of the individual or entity to which they are addressed. If you are not the intended recipient, you are hereby notified that any use or dissemination of this communication is strictly prohibited. If you have received this e-mail in error, please notify us immediately, then delete this e-mail. Please note that William Hill can accept no responsibility for viruses and it is your responsibility to scan any emails and their attachments. This message was from William Hill PLC whose registered office is Greenside House, 50 Station Road, Wood Green, London N22 7TP. Company Registration Number: 4212563 England. ******************************************** ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/