Try this: Select * From MYTABLE Where MYCOLUMN Like "%Richard%" or Select * From MYTABLE Where InStr(1, MYCOLUMN, "Richard") > 0
Replace: MYTABLE with the name of your table MYCOLUMN with the name of the "Company Name" column I'm not which is fastest, but they should do the same thing. Note that the "%" in the first expression can be replaced with an underscore "_", which then means exactly 1 character. The "%" means 0, 1 or several characters. Peter Horsbøll Møller GIS Developer Geographical Information & IT COWI A/S Odensevej 95 DK-5260 Odense S Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk *****CHANGE OF ADDRESS - COWI's offices in Odense are now under the same roof***** On December 8th. 2003, Geographical Information & IT moved from Rugaardsvej 55, 5000 Odense C to Odensevej 95, 5260 Odense S. Please note our new telephone, direct and telefax numbers. > -----Original Message----- > From: Richard Hill [mailto:[EMAIL PROTECTED] > Sent: Wednesday, January 14, 2004 7:07 AM > To: 'Mapinfo-List' > Subject: MI-L SQL Queries > > > Hello Folks, > This is a straight forward request, but I am not yet familiar > with SQL. > > I have a Mapinfo table from which I want to select all > records in which a specific name appears in the "Company > Name" column. However (and this is the limit of my > understanding of SQL) the name could be (for example) > "Richard enterprises", "Richard Pty Ltd", "The really good > Richard Company" (you get the idea?) dispersed among several > thousand records. So I want to only select those records in > which the name "Richard" appears in the string in the > "Company Name" column. > > OK, Folks, Thanks > > Richard Hill, > Southern Titanium NL > --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 9871