Re: MI sql selecting text (partial)

[Bob Young - www.bydesignwales.demon.co.uk]

Dear Mike

Yes Mapinfo offers two wildcards just like DOS.

The equivalent to DOS ? is _(underscore). ie represents 1 ( any 1 )
character.

The equivalent to * is %(per cent). This can represent from 0 to any
number of chars.

So if you search for %Main% you will get all of your Mains.

When MI does such a fuzzy search it cannot take advantage of indexes so
depending on your table size you might find this slower tan standard
searches.

Good Luck


Bob
Bob Young
By Design




In message <[EMAIL PROTECTED]
ent.com>, Lepage, Mike L (Mike)** CTR ** <[EMAIL PROTECTED]> writes
>All,
>
>I have no problem with selecting text from a column with the sql, but I find
>that it has to be an exact match to return something.
>
>Is there another select command or function where it would match to a part
>of the text?
>
>for example 1 main ave.
>if I search for "main" it would return all the rows with "main" in it so I
>don't have to worry about the ave or avenue type stuff.
>
>thanks,
>
>
>----------------------------------------------------------------------
>To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
>"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]

-- 
Bob Young - www.bydesignwales.demon.co.uk
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]