Hi Richard Easy. I am new as well to MapInfo, but I am getting there. This is what you do: click Query>SQL Select, then on the dialog box
Select Colums: * >From Tables: Table Name you want to select from Where Condition: Company Name like "Richard%" Group by olumns: Order by Columns: into table Name: Whatever_you_want Hope that addresses your question. Regards, Norman Mabunda Manager: GIS and Databases [EMAIL PROTECTED] +27 12 312 0843 (Tel) +27 12 312 0642 (fax) +27 73 265 9279 (cell) NATIONAL DEPARTMENT OF HEALTH NATIONAL HEALTH INFORMATION SYSTEMS www.doh.gov.za our home page www.doh.gov.za/nhis/index.html National Health Information System www.gov.za South African Government Hopepage "If One Door Of Opportunity Closes, The Other One Opens" >>> "Richard Hill" <[EMAIL PROTECTED]> 01/14/04 08:06AM >>> 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
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=Content-Type content="text/html; charset=iso-8859-1"> <META content="MSHTML 6.00.2800.1106" name=GENERATOR></HEAD> <BODY style="MARGIN-TOP: 2px; FONT: 8pt Tahoma; MARGIN-LEFT: 2px"> <DIV><FONT size=1>Hi Richard</FONT></DIV> <DIV><FONT size=1></FONT> </DIV> <DIV><FONT size=1>Easy. I am new as well to MapInfo, but I am getting there. This is what you do: click Query>SQL Select, then on the dialog box</FONT></DIV> <DIV><FONT size=1></FONT> </DIV> <DIV><FONT size=1>Select Colums: *</FONT></DIV> <DIV><FONT size=1></FONT> </DIV> <DIV><FONT size=1>From Tables: Table Name you want to select from</FONT></DIV> <DIV><FONT size=1></FONT> </DIV> <DIV><FONT size=1>Where Condition: Company Name like "Richard%"</FONT></DIV> <DIV><FONT size=1></FONT> </DIV> <DIV><FONT size=1>Group by olumns:</FONT></DIV> <DIV><FONT size=1></FONT> </DIV> <DIV><FONT size=1>Order by Columns:</FONT></DIV> <DIV><FONT size=1></FONT> </DIV> <DIV><FONT size=1>into table Name: Whatever_you_want</FONT></DIV> <DIV><FONT size=1></FONT> </DIV> <DIV><FONT size=1>Hope that addresses your question.</FONT></DIV> <DIV><FONT size=1></FONT> </DIV> <DIV><FONT size=1>Regards,</FONT></DIV> <DIV> </DIV> <DIV> </DIV> <DIV> </DIV> <DIV>Norman Mabunda <BR>Manager: GIS and Databases <BR><A href="mailto:[EMAIL PROTECTED]">[EMAIL PROTECTED]</A> <BR>+27 12 312 0843 (Tel) <BR>+27 12 312 0642 (fax) <BR>+27 73 265 9279 (cell) </DIV> <DIV> </DIV> <DIV>NATIONAL DEPARTMENT OF HEALTH <BR>NATIONAL HEALTH INFORMATION SYSTEMS</DIV> <DIV> </DIV> <DIV><A href="http://www.doh.gov.za";>www.doh.gov.za</A> our home page<BR><A href="http://www.doh.gov.za/nhis/index.html";>www.doh.gov.za/nhis/index.html</A> National Health Information System<BR><A href="http://www.gov.za";>www.gov.za</A> South African Government Hopepage</DIV> <DIV> </DIV> <DIV>"If One Door Of Opportunity Closes, The Other One Opens"<BR><BR>>>> "Richard Hill" <[EMAIL PROTECTED]> 01/14/04 08:06AM >>><BR>Hello Folks,<BR>This is a straight forward request, but I am not yet familiar with SQL.<BR><BR>I have a Mapinfo table from which I want to select all records in which<BR>a specific name appears in the "Company Name" column. However (and this<BR>is the limit of my understanding of SQL) the name could be (for example)<BR>"Richard enterprises", "Richard Pty Ltd", "The really good Richard<BR>Company" (you get the idea?) dispersed among several thousand records.<BR>So I want to only select those records in which the name "Richard"<BR>appears in the string in the "Company Name" column.<BR><BR>OK, Folks, Thanks<BR><BR>Richard Hill,<BR>Southern Titanium NL<BR></DIV></BODY></HTML>
--------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 9873
