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]