Dear all, A quick summary of the responses I recieved for the interested parties is as follows: Basically I have been alerted to the fact that the "Contains" operator is a geographic operator and therefore cannot query text strings...Typical! So heres what I should have done and have since done with complete success... OS_Text Like "%Car Park%". Marvellous! Thanks again all. Dave ------- Forwarded message follows ------- From: "David Eagle" <[EMAIL PROTECTED]> Organization: W S Atkins East Anglia To: [EMAIL PROTECTED] Date sent: Fri, 11 Feb 2000 16:49:25 -0000 Subject: MI Query "Contains" Ok, heres a problem which I have come accross before and gave up on...It's cropped up again, and I don't want it to beat me again so here goes... It relates to the query function and is no doubt blindingly simple: I have a browser full of info, Lndl_gaz (OS) to be precise. I want to select all of the items which mention Car Parks. I have tried the obvious: (Table Lndl_gaz) OS_Text Contains "Car Park" I get a data mismatch in expression and a syntax error! It seems that this is a logical way of trying to get a result but despite interrogating numerous help files, I am still failing... If I manage this what would be really useful is working out how to perform the query relating to another table and therefore selecting all the car park entries that fall within a 3 Mile buffer circle that I have setup on another table.... Any help would ease my frustration. Rgds, Dave _________________________________________________________ David A. Eagle (Graduate Analyst). WS Atkins Consultants - East Anglia Wellbrook Court, Girton Road, Cambridge, CB3 0NA. Tel: (01223) 276002, 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] ------- End of forwarded message ------- _________________________________________________________ David A. Eagle (Graduate Analyst). WS Atkins Consultants - East Anglia Wellbrook Court, Girton Road, Cambridge, CB3 0NA. Tel: (01223) 276002, 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]
