Thanks guys...3 replies and 3 slightly different ways to do it! I couldn't quite get Toms to work though, it wasn't having it at all... Anyway, thank you! Question: This is a very simple query select but I can't work out how to do it! I have a column which has a code within it refering to mode of transport...I want to select all the records that equal codes 4,5,12,13 & 14...(These represent cars (with different no.s of passengers and mcycles)). I can select them individually with: column = 14 but have tried numerous ways of multi selecting to no avail...Can someone please solve this simple but annoying problem for me... TIA, Dave Answers: From: PERRY Chris<[EMAIL PROTECTED]> To: "'David Eagle'" <[EMAIL PROTECTED]> Subject: RE: MI Multi select Date sent: Thu, 15 Jun 2000 20:28:13 +1000 David, the key here is the word ANY... Try: column=any(4,5,12,13,14) From: "laurentFrilleux"<[EMAIL PROTECTED]> To: "David Eagle" <[EMAIL PROTECTED]> Subject: Re: MI Multi select Date sent: Thu, 15 Jun 2000 12:20:16 +0100 hello try to select your code by select code =4 or code = 5 or code=.... From: Tom Manson <[EMAIL PROTECTED]> To: "'David Eagle'" <[EMAIL PROTECTED]> Subject: RE: MI Multi select Date sent: Thu, 15 Jun 2000 11:39:16 +0100 Try this: column like any(2,3,14,etc....) I've only done this with character fields, but integer should also work. Tom _________________________________________________________ David A. Eagle WS Atkins Consultants - East Anglia Wellbrook Court, Girton Road, Cambridge, CB3 0NA. Direct Dial Tel: (01223) 814090, Fax: (01223) 277529 E-Mail: [EMAIL PROTECTED] ---------------------------------------------------------------------- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
