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 Street_table where InStr(1, Street_name, "1") > 0 
This gives me everything with "1" in it, ie. 1,12,15,121,413,531, etc....
How can I just select those with the single character "1"

TIA

Steve



_______________________________________________________________________
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, send e-mail to [EMAIL PROTECTED] and
put "unsubscribe MapInfo-L" in the message body.

Reply via email to