[MI-L] How to do intersection with two layers?

Hi All, I have two tables with maps. One is Buffer layer, the other is District layer. I want to get feathers both within buffer and district layers and set the features to a new field to the buffer table. How to do this? Thanks! Best regards, Noaa

RE: Ang. Re: [MI-L] voronoi polgon

I'm not sure if this is know by all, but you can actually control the area that the voronoi regions should cover, simply by selecting a region object and setting this object as the target area. This will tell MapInfo to extend the voronoi regions to the borders of the target area. Nice, eh ?

[MI-L] SQL selecting carriage returns or line feeds in browser

Greetings Everyone, I have a label table in which some labels with multiple words have carriage returns or line feeds between words. I have updated the background data with the text of the label _Objectinfo(obj,3)_ I wish to select only the records which have line feeds or carriage returns

[MI-L] Re: SQL selecting carriage returns or line feeds in browser

What is happening here is that: LABEL like %Chr$(13)% is looking for the literal value of Chr$(13) The function Chr$(13) is never executed so it does not return the value of carriage return (line feed or any other special char) Try this method ie LABEL like % + Chr$(13) + % or try using

[MI-L] Creating Labels using Space as a delimiter....

Howdy, I have a field containing formatted street address (eg 27a Smith St, Smithfield ) and I want to create a label displaying just the house number (eg 27a). I'm using MapInfo Pro Version 6.0. Have looked at all the label string functions as hoped to use the first space in the string

RE: [MI-L] Creating Labels using Space as a delimiter....

Have you tried: Left$([YOURFIELD],Instr(1,[YOURFIELD], )-1) HTH David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Gosbell Sent: Sunday, January 15, 2006 11:06 PM To: mapinfo-l@lists.directionsmag.com Subject: [MI-L] Creating Labels using Space

RE: [MI-L] Creating Labels using Space as a delimiter....

Try: Left$(MyColumn, InStr(1, MyColumn, )-1) In this instance, InStr() returns the position of the first space character. Subtract 1 from this to exclude the space itself in the label. Cheers, Peter -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of

RE: [MI-L] Creating Labels using Space as a delimiter....

here ya go, this should werk... # Left$(YOURFIELD, InStr(1, YOURFIELD+ , )-1) # the YOURFIELD+ is in case your field value doesn't have a space in one of them so it won't return zero on the instr command, it'll give back 1 greater than the len of the