Hi Mike Try using this the Instr() or Like() functions in your SQL Select * from MyTab Where Instr(1, MyColm, "main") > 0 Or this Select * from MyTab where Like(MyColm, %main%, "") NB the Instr() and the Like() Functions are case-sensitive, in this exampel it will only locate main but not Main or MAIN . If you will find both main and MAIN try using the LCase$() function, like this Select * from MyTab where Like(LCase$(MyColm), %main%, "") Peter Laulund National Survey and Cadastre, Denamrk "Lepage, Mike L (Mike)** CTR **" <[EMAIL PROTECTED]> - 11-11-99 15:55:48 Til: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> cc: (bcc: Peter Laulund/MI/KMS) Vedrørende: MI sql selecting text (partial)
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]
