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]