Hi David just type this in the mapbasic window Select * from MyTab where MyColm in (4,5,12,13, 14, etc. ) Peter Laulund National Survey and Cadastre, Denmark "David Eagle" <[EMAIL PROTECTED]> - 2000 06 15 10:43:48 Til: [EMAIL PROTECTED] cc: (bcc: Peter Laulund/MI/KMS) Vedrørende: MI Multi select
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 _________________________________________________________ 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]