Gratitude to everyone responding - (was: MI - Expressions in "Select")
I know "Thank You" postings probably rate in the "you don't have to, it's assumed you appreciate the help" category. But I just had to post a Thanks anyway and sincerely hope that the folks that responded with assistance, happen to glance over this. Many Many thanks from a Forest Ranger moonlighting as a cartographer! Thanks to you, I won't have to call the Hair Club For Men any sooner than necessary! Hairline is now back at normal rate of decent! or would that be ascent? THANKS ANYWAY : )) __ David Reid [EMAIL PROTECTED] -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
Re: MI - Expressions in "Select"
Dear David, If you want to use wild-card characters in a string expression you have to use the word LIKE instead of =. The wild-card character % (percent) matches zero or more characters. The wild-card character _ (underscore) matches a single character. So your where clause should look like: Where PLUGS like "%" Jens Kuegl > "Select" expressions. I have been through the help files til I'm > cross-eyed trying to create a simple select expression to select only > the cells of a record that contain a single first character followed > by any number of characters. > > Example: PLUGS = "G??" to select all the PLUGS rated at "Gxx" > -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
RE: MI - Expressions in "Select"
David- Try using left$(PLUGS,1)="G" where the 1 is the number of characters on the left side of the string. If you needed all the G1xx plugs for example, you'd enter left$(PLUGS,2)="G1". Same for the right side (right$(column,#chars)="xxx") Jason ¤»¥«¤»§«¤»¥«¤»§«¤»¥«¤» Jason Adam Computer Draftsperson Monopros Limited Toronto, ON [EMAIL PROTECTED] > -Original Message- > From: David Reid [SMTP:[EMAIL PROTECTED]] > Sent: Monday, January 17, 2000 1:58 AM > To: [EMAIL PROTECTED] > Subject: MI - Expressions in "Select" > > Please help me save what's left of my already receding hair line and > prevent me from pulling the rest of my hair out. > > "Select" expressions. I have been through the help files til I'm > cross-eyed trying to create a simple select expression to select only > the cells of a record that contain a single first character followed > by any number of characters. > > Example: PLUGS = "G??" to select all the PLUGS rated at "Gxx" > > __ > David Reid > [EMAIL PROTECTED] > > > -- > To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put > "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED] -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
MI - Expressions in "Select"
Please help me save what's left of my already receding hair line and prevent me from pulling the rest of my hair out. "Select" expressions. I have been through the help files til I'm cross-eyed trying to create a simple select expression to select only the cells of a record that contain a single first character followed by any number of characters. Example: PLUGS = "G??" to select all the PLUGS rated at "Gxx" __ David Reid [EMAIL PROTECTED] -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]