[MI-L] Intelligent Node Thinning

2005-11-21 Thread Morrier, Steve
Hi All, Does anyone know of a tool that will do intelligent node thinning? We have extracted a large number of forest blocks from 75cm aerial photography using a spectral classification. The classification produces a very "stepped" looking polygon with far too many nodes/points. I would

RE: MI-L Square Buffer

2005-04-27 Thread Morrier, Steve
Hi All, I had asked this question earlier and got directed to a Half Buffer tool by Jacques Paris. Unfortunately this isn't the tool I need. I need a tool that will create a buffer from a line but instead of the usual rounded end I just want the buffer to square off each end of the line. Is there

MI-L Square Buffer

2005-04-14 Thread Morrier, Steve
Hi All, Is there a way to create a buffer on a line that has a square end instead of a spherical end? TIA? Steve - List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL

MI-L VMAP1 Data Dicitonary

2004-10-25 Thread Morrier, Steve
Hi All, Does anyone know where I can find a data dictionary for VMAP1 data? TIA Steve Morrier Terrain Database Development, xwave Simulation and Training Voice: (613) 831-0888 (x7920) Fax: (613) 836-8084 Toll Free: (800) 414-9130 Email:[EMAIL PROTECTED]

MI-L Right Angle Tool

2004-06-11 Thread Morrier, Steve
Hi All, Does anyone know of a tool that will allow you to draw right angle polygons? I have to digitize a bunch of building footprints and want to make sure that the corners of the footprints are perpendicular. Thanks for your help. Steve

MI-L Random Number Ranges....

2004-06-10 Thread Morrier, Steve
Hi All, Is there a way to update a column with random numbers that fall within a certain range? I would like to update 500+ records with a value between 5 and 150. Is this possible? TIA Steve - List hosting provided by

RE: MI-L Random Number Ranges....

2004-06-10 Thread Morrier, Steve
. _ From: Ben A Greenberg [mailto:[EMAIL PROTECTED] Sent: Thursday, June 10, 2004 2:43 PM To: Morrier, Steve; [EMAIL PROTECTED] Subject: RE: MI-L Random Number Ranges Updating the column with: 5 + (rnd(1) * 145) should give you a random number between 5 and 150 Ben

RE: MI-L Random Number Ranges....

2004-06-10 Thread Morrier, Steve
Please disregard that question I am an idiot. I will just generate random numbers between 1 and 15 and then multiply by 5. Sorry for the stupid question. -Original Message- From: Morrier, Steve Sent: Thursday, June 10, 2004 2:54 PM To: [EMAIL PROTECTED] Subject: RE: MI-L Random Number

RE: MI-L Area Calculation

2003-07-24 Thread Morrier, Steve
Hehehe never mind, I'm a boob, figured it out. -Original Message- From: Morrier, Steve Sent: Thursday, July 24, 2003 2:10 PM To: [EMAIL PROTECTED] Subject: MI-L Area Calculation Hi All, I have a region file that is full of small polygons. What is the correct syntax and column type

MI-L ArcLink

2003-06-06 Thread Morrier, Steve
Anyone know where I can download the ArcLink MBX ? TIA. Steve - List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

RE: MI-L ArcLink

2003-06-06 Thread Morrier, Steve
Can someone send me a copy of ArcLink? Please! Thank you. Steve -Original Message- From: Morrier, Steve Sent: Thursday, June 05, 2003 10:20 AM To: [EMAIL PROTECTED] Subject: MI-L ArcLink Anyone know where I can download the ArcLink MBX ? TIA. Steve

MI-L ADRG??? CDRG??? IMG ???

2003-05-30 Thread Morrier, Steve
Hi All, I have a kind of vague question. A coworker has asked me to help him import what he believes is an ADRG file into a program called Manifold System. I am unfamiliar with Manifold System and only know that it will allow the import of CADRG files and not ADRG. To compound the issue I don't

MI-L RE: [erdas-l] Re: ADRG??? CDRG??? IMG ???

2003-05-30 Thread Morrier, Steve
and some of the others still working this stuff can either back me up or correct me. But, if memory is correct, ADRG is the acronym for Air Defense Raster Graphic, the digital form of the old JOGAs, probably at 250K scale. Might want to see if NIMA will assist. jd On Thu, 29 May 2003, Morrier

MI-L Projection help

2003-03-11 Thread Morrier, Steve
Why wont this work?? This is the projection of the Shape file I am translating; PROJCS[NAD_1983_CSRS98_New_Brunswick_Stereographic, GEOGCS[GCS_North_American_1983_CSRS98, DATUM[D_North_American_1983_CSRS98, SPHEROID[GRS_1980,6378137.0,298.257222101]], PRIMEM[Greenwich,0.0],

MI-L Sort by Maximum

2003-03-04 Thread Morrier, Steve
Hi All, Is there a simple way to sort a table in descending order? I'm sure there is. I have a Street file that I would like to sort by address ranges, but I would like the address ranges to start at the maximum value and go down. I have tried sticking a Max clause in the Order By row of the SQL

RE: MI-L Sort by Maximum

2003-03-04 Thread Morrier, Steve
Thanks to all who responded so quickly, I knew there was a way to do it! Thanks again! Steve -Original Message- From: Morrier, Steve Sent: Tuesday, March 04, 2003 2:26 PM To: MapInfo List Subject: MI-L Sort by Maximum Hi All, Is there a simple way to sort a table in descending order

MI-L Orthophoto Help

2003-02-12 Thread Morrier, Steve
Hi all, I am trying to split an orthophoto into 3 managable parts. The orginal photo is 500Mb and covers a larger area than I need. I know this about the photo; UL: 509 972.125mE, 5 431 308.975mN Pixels: 21745x7195 Image size: 6523.65m x2374.5m I believe the spatial resolution is roughly 0.3m

RE: MI-L Attention NYC residents

2003-01-14 Thread Morrier, Steve
If terrorists want the coordinates of a landmark in NY they would buy a $100 GPS unit and get them. Try and keep some perspective. Sorry I don't have the information you want Alex. -Original Message- From: B. Thoen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 14, 2003 10:50 AM To:

MI-L Duplicate Nodes

2002-12-17 Thread Morrier, Steve
Hi All, Does anyone have a little MBX or trick that will allow you to quickly(ie. click one button) move back and forth between moving duplicate nodes in the same layer and not moving them? I am trying to avoid having to go back and forth between Option/Preferences/Map Window/Move Duplicate Nodes

MI-L Intersection Snap Tool

2002-11-07 Thread Morrier, Steve
Hi All, Does anyone know of a tool that will check an intersection to dertime if the end nodes are snapped together or not? I have a bunch of street intersections that are not properly snapped and would like to be able to select them and correct the problem. TIA. Steve

MI-L Address Range Overlap

2002-11-06 Thread Morrier, Steve
Hi All, I am not sure if this one can be done or not but I am hoping some Street File guru can help me. Is there a way to find all street segments that have an overlap in their address ranges? For example one block/segment of Main St. may have a FromLeft =20 and ToLeft = 30, I want to check to

MI-L Check Selection

2002-11-06 Thread Morrier, Steve
Hi All, What is the simplest way in MapBasic to run a quick check to see if anything has been selected in a table? I want to run a quick routine which works fine but if I don't have anything selected and I hit the button to run the routine/MBX the whole thing craps out. Do I need a check or just

MI-L Creating a Grid for Orthophotos

2002-11-01 Thread Morrier, Steve
Hi All, I have about 140 orthophotos for an area. I would like to create a grid file to represent the location/coverage of the orthophotos. Is there a simple way to do this? Since they are orthophotos there is a small amount of overlap between photos and most of the photos are of slightly

MI-L Projection Help

2002-10-07 Thread Morrier, Steve
Hi All, I need your help with adding to my MAPINFO.prj file again. I thought I had it figured out but was wrong. This is what I have on the original projection: Projection: Transverse Mercator Spheroid: GRS 80 Central Meridian:-76.5 Reference Latitude:0 Scale Factor: 0. False

RE: MI-L Projection Help

2002-10-07 Thread Morrier, Steve
Sorry I forgot to add the 7 for metres but am still having some trouble with the prj file. -Original Message- From: Morrier, Steve [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 3:14 PM To: [EMAIL PROTECTED] Subject: MI-L Projection Help Hi All, I need your help

MI-L Splitting Data

2002-10-04 Thread Morrier, Steve
Hello All, I am sure there is a way to do this but I haven't figured it out yet. I have over 3000 records of street names that look like this; ALLEYS MILL RD - RTE 4 I would like to run a query or an update column routine that would split the column at the - (dash) and update column1 with

MI-L BC albers Projection

2002-10-02 Thread Morrier, Steve
Hello all, Does anyone know the proper format to use to include the BC Albers in MapInfo projection file? I am importing and E00 and the projection is not available as a choice. The projection is Albers Equal Area Conic, with parameters of : Central meridian: -126.0 (126:00:00 West longitude)

MI-L BC Hydro

2002-10-01 Thread Morrier, Steve
Hello, Does anyone have a hydrology layer for British Columbia they would be willing to give away for free? I am specifically interested in the Squamish-Whistler-North Vancouver area. Thanks very much. Steve PS I have already downloaded the drainage file from GeoGratis but it is too course.

MI-L SELECT ONLY....

2002-09-24 Thread Morrier, Steve
Hi all, Is there a way to start and stop a selection? I want to select all records that have; CR - I am looking for Street Names which are Crescents (CR). If I do the following search; InStr(1, Street_Name, CR )0 It returns most of the streets I want but also streets with names like Ocean

RE: MI-L SELECT ONLY....

2002-09-24 Thread Morrier, Steve
Thanks very much to all who replied, I have enough to work with now. Steve -Original Message- From: Coubes, Sophie [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 2:07 PM To: Morrier, Steve; MI Questions Subject: RE: MI-L SELECT ONLY Hi Steve, Try this : Select

MI-L Left/Right Join

2002-09-09 Thread Morrier, Steve
Hi All, Last March I posted the following question, someone responded and sent me a great little app that let me do exactly what I wanted. I have since lost the app and the persons email. If you remember this or have the app I am talking about please email me it again. Thanks very much. Steve

MI-L Projections

2002-08-12 Thread Morrier, Steve
this? Are there any other projection utilities I can try? Is there a header type file that I could open in a text editor and force the bounds of the data to fit where I want it to? TIA. Steve -Original Message- From: Morrier, Steve [mailto:[EMAIL PROTECTED]] Sent: Friday, August 09, 2002

MI-L Projections

2002-08-09 Thread Morrier, Steve
Hi All, I am trying to import an ESRI shape file using the Universal Translator. The import works fine until I try and change the projection. I want a Lat/Long NAD83 projection, if I try and change projection during import then nothing appears in the map browser althought the translation was

MI-L Shortcut Keys

2002-07-24 Thread Morrier, Steve
Hi All, Is there a way to change the actions of short cut keys? So instead of Ctrl + T setting target it could Buffer? Or have a new on such as Ctrl + E = Erase? TIA. Steve

RE: MI-L Template for Text Editor

2002-07-10 Thread Morrier, Steve
I have been using MBCoder by Trey Pattillo at www.wap3.com, [EMAIL PROTECTED] It is free and does most of the things you mentioned. For an extra $45 (i think) he also has a dialogue builder application. Hope this helps. Steve -Original Message- From: Eric Frost - HRA [mailto:[EMAIL

MI-L Tables as Variables

2002-06-21 Thread Morrier, Steve
Hi all, I have searched the archives and I can create a list of all the open tables, I can determine if a given table is open but I still can't figure out how create a variable that will contain the currently opened table. I have a Close All statement so they should only be one open table at any

MI-L No Selection!

2002-06-14 Thread Morrier, Steve
Hi All, I am trying to write a little If..Then statement that first checks if a table is open, then runs a query on the table. The problem I am having is when no records are selected. What is the syntax for saying something along the lines of; If No records selected then resume next ---

MI-L Address Ranges from Points

2002-06-13 Thread Morrier, Steve
Hi All, Does anyone have any experience with assigning address ranges to Street(line) segments from point data? I have a street file with names and types but no address ranges. My addresses are individual civic addresses(points). I would like to be able to assign From_Left and To_left,

MI-L Adding a Graphic to a dialogue

2002-06-11 Thread Morrier, Steve
Hi All, Does anyone know how to add an icon or bitmap to a dialogue box? TIA Steve This communication (including all attachments) is intended solely for the use of the person or persons to whom it is addressed and

MI-L Checkboxes

2002-06-05 Thread Morrier, Steve
Hi All, I have 2 check boxes that I have added to a dialogue box I am building in MapBasic. How can I make it so that only one check box can be selected? I don't want a warning saying both boxes can't be checked, just want one to clear if the other is selected. Is this possible? TIA. Steve

MI-L Find Selection??

2002-06-04 Thread Morrier, Steve
Hi All, I have a small script where the user can add a new row to an open table. Is there any way to have the browser automatically move to the newly added row so it is displayed? I am trying to avoid having the user have to scroll down to the bottom of the table to see the newly added row. TIA.

MI-L Number of Rows

2002-06-04 Thread Morrier, Steve
HI again, Is there a way, in MapBasic, to determine the number of rows in any given table? TIA Steve -Original Message- From: Christian McNierney [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 04, 2002 12:51 PM To: [EMAIL PROTECTED] Subject: RE: MI-L Update Area 1 sq. mile = 259

MI-L Menu Syntax

2002-05-29 Thread Morrier, Steve
Hi again! Does anyone know the correct syntax to create a sub menu in MapBasic? I would like something similar to how the Table menu works, where you can select Table/Maintenance/Pack Table. If someone could provide me with the correct code for this I would be very happy. TIA. Steve

MI-L Add Row

2002-05-28 Thread Morrier, Steve
Hi Listers, How the heck do you add a row to a table in MI? I know you can append rows from other tables or from a selection within a table but I just want to add an empty row to the bottom of my table. The table is not mapable and is just 3 columns of metadata. Any help would be appreciated.

RE: MI-L Add Row

2002-05-28 Thread Morrier, Steve
Doh! Edit/new row Thank you! Why isn't this under TABLE??? -Original Message- From: Morrier, Steve [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 28, 2002 9:23 AM To: [EMAIL PROTECTED] Subject: MI-L Add Row Hi Listers, How the heck do you add a row to a table in MI? I know you can

MI-L ProViewer

2002-05-22 Thread Morrier, Steve
Has anyone used ProViewer? I would like something our clients could use to load up data sets and do very basic changes such as editing names in a table. Does ProViewer allow for any editting? And add-ons that you know that can do what I want? TIA Steve -Original Message- From: [EMAIL

MI-L SQL Select

2002-03-06 Thread Morrier, Steve
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. Hi all, Is there a simple way to select the records in the same table that have = the same name and the same second variable? I want to be able to select all

MI-L SQL Help

2002-02-28 Thread Morrier, Steve
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. Hi all, I have what I thought would be an easy query but it is giving me problems. I have 2 street files, one new and one old. They have roughly the same

RE: MI-L SQL Help

2002-02-28 Thread Morrier, Steve
, 2002 12:13 PM To: 'Morrier, Steve'; MapInfo-L (E-mail) Subject: RE: MI-L SQL Help Steve, Not to worry, you won't get fired. Remember we are the ones who actually do the work! Here is a method for selecting records in one table that do not match records in another table. Consider a situation

MI-L Odd-Even Query

2002-02-27 Thread Morrier, Steve
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. Hi all, Is it possible to query a table for odd or even values? I have an address table and want to make sure the address ranges for FromLeft - ToLeft contain

MI-L Extracting Node Coordinates

2002-02-22 Thread Morrier, Steve
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. Hi all, I am trying to create a text file that would contain the coordinates of all the nodes along a route. So I would select a route at random through a

MI-L Date Stamp

2002-01-30 Thread Morrier, Steve
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. Hi all, Is there a way to put a modification date stamp on a row after it has been editted? I work with large street files and would like to have an automatic

MI-L Reprojection Tool?

2002-01-29 Thread Morrier, Steve
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. Hi all, Are there any good (free) reprojection tools available for MI? I have a file with a NonEarth projection that looks like it may be a variation of a UTM

RE: MI-L Reprojection Tool?

2002-01-29 Thread Morrier, Steve
: Tuesday, January 29, 2002 1:59 PM To: Morrier, Steve Cc: 'MapInfo-L (E-mail)' Subject: Re: MI-L Reprojection Tool? You can export the file to DXF then import the DXF file, choose your UTM projection. Open the new MapInfo table that was created, save as Lambert Conic. Another option would

MI-L Buffer reduction

2002-01-03 Thread Morrier, Steve
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. boundary=_=_NextPart_001_01C19471.710CD2E2 --_=_NextPart_001_01C19471.710CD2E2 Hi all, This is a bit hard to explain but I will try. I

MI-L Interactive Internet Mapping

2001-12-19 Thread Morrier, Steve
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. Hi all, A while back I posted a question on Internet Mapping solutions. I received many suggestions and thanks to all those who responded. However I found

MI-L SQL Multi-table

2001-12-18 Thread Morrier, Steve
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. Hi All, I am sure this is a simple question for most but I am a syntax weenie and can't get it to work. I have 2 street tables, the original and the new one.

MI-L Internet Mapping

2001-12-03 Thread Morrier, Steve
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. Hi all, I am trying to find information on what software and hardware requirements and skills are necessary to start an Internet mapping project. I work with

MI-L Batch Combine??

2001-10-23 Thread Morrier, Steve
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. Hi all, Is there a way to quickly combine row/objects based on a similar attribute? I have a hyro layer where one lake can be made up of several polygons. Is

RE: MI-L Friday Funny: Taliban TV guide

2001-10-19 Thread Morrier, Steve
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. Is there such a thing!?!? :-) -Original Message- From: Bendall,A EPO [mailto:[EMAIL PROTECTED]] Sent: Friday, October 19, 2001 9:49 AM To: Issa Smith;

RE: MI-L Friday Funny: Taliban TV guide

2001-10-19 Thread Morrier, Steve
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. Knock, knock, who's there? Yukon Yukon who? Yukon never get bored of geography :-) -Original Message- From: Eric Frost [mailto:[EMAIL PROTECTED]]

MI-L Broken Line Segment

2001-10-19 Thread Morrier, Steve
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. Hi all, Is there a way to select line segments that have a break in them? I am trying to find all the lines that have a gap or break in them so that I can get

RE: MI-L Difference between 2 images

2001-10-04 Thread Morrier, Steve
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. Hi Stephen, If the images are not orthocorrected or at least geo-corrected then image differencing will not be accurate at all for change detection. So if you

MI-L In String Selection

2001-09-28 Thread Morrier, Steve
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. Hi All, Is there a way to select only the character 1 (not number)from a string without getting every address with 1 in it? I am using Select from

RE: MI-L In String Selection

2001-09-28 Thread Morrier, Steve
and is not followed by any other characters. Not sure if this can be done or not but I appreciate all the help I have been getting, thanks again. Steve -Original Message- From: Morrier, Steve [mailto:[EMAIL PROTECTED]] Sent: Friday, September 28, 2001 10:04 AM To: '[EMAIL PROTECTED]' Subject

RE: MI-L In String Selection

2001-09-28 Thread Morrier, Steve
I will get what I am looking for. Thanks to all, and sorry for the waste of time. Embarrassed -Original Message- From: Morrier, Steve [mailto:[EMAIL PROTECTED]] Sent: Friday, September 28, 2001 11:05 AM To: '[EMAIL PROTECTED]' Subject: RE: MI-L In String Selection This message

MI-L Lower Case

2001-09-26 Thread Morrier, Steve
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. Hi all, Is there a quick way to convert all upper case letters in a column to lower case letters? TIA. Steve -Original Message- From: Karen Purdy

MI-L Join - Update Column

2001-09-11 Thread Morrier, Steve
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. Hi all, Is there a way to update a column using the Join command for a point and line file? I have a city_name column in my street file and want to update

MI-L Column Update

2001-08-31 Thread Morrier, Steve
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. Hi Again, Is it possible to update more than one column simultaneously if the data you are updating is the same for both or all columns? For example I have 3

MI-L More SQL Help Please

2001-08-30 Thread Morrier, Steve
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. Hi All, What is the correct approach or syntax to select all the streets in my street file that are within a township of my municipality (polygon layer) file?

MI-L Text Deletion

2001-08-23 Thread Morrier, Steve
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. Hi all, Is it possible to select just a few characters in a column and automatically delete those characters, leaving just the text you want? For example I

MI-L Text Deletion

2001-08-23 Thread Morrier, Steve
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. Thanks to all who responded so quickly, seems like the best solution is a MBX program that actually comes with MapInfo call srchrepl.mbx. Thanks again. Steve

MI-L 2 Questions

2001-06-28 Thread Morrier, Steve
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. Hello all, 1) I recently asked a question about reducing the number of nodes after an area has been clipped, all the suggestions I received work only on lines

MI-L Node Reduction

2001-06-26 Thread Morrier, Steve
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. Hello all, I am doing a lot of splitting of large polygons into smaller ones and every new polygon seems to have thousands of nodes after the split. The

MI-L Repeat Question

2001-04-27 Thread Morrier, Steve
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. Hi I know I asked this earlier but I accidently deleted all my saved emails and I have no short-term memory so.. What is the correct syntax for selecting

MI-L Table Update

2001-04-25 Thread Morrier, Steve
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. I have done a SQL to select the records from a large table that I wanted to edit. I needed to temporarily change the table structure so I did a save copy

MI-L SQL

2001-04-24 Thread Morrier, Steve
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. Another dumb question. What is the correct syntax to select all records from a column where the condition is that I want all strings with more than 19

MI-L Column Swapping?

2001-03-28 Thread Morrier, Steve
Is there any way to swap the values in one column with the values of another? I have a huge street file database and the "to" and "from" values for some of the streets are reversed. Besides selecting the streets in question, deleting them from the original table and just changing the column

MI-L SQL

2001-03-16 Thread Morrier, Steve
What is the correct syntax for selecting all rows in a table where the first letter is A followed by a number? For example I want to select all the rows where the ID range of a column is A - A12. Thanks for your help ___

MI-L SQL Select

2001-03-09 Thread Morrier, Steve
Does anybody know the proper syntax for selecting on those records within a field that contain two words or more. I need to select all street names with in a file that are more than one word. Basically I am concerned with any entry that has a space in it. Any help would be greatly appreciated.

MI-L SQL

2001-03-09 Thread Morrier, Steve
Thanks to all who responded so quickly. The following both worked instr(1,Col_Name," ")0 or Select * from STREETS where Instr(1, STREETNAME, " ") ___ List hosting provided by Directions Magazine | www.directionsmag.com | To