David,

The appropriate "operator" for SELECTs (or any "SQL" operation") where 
wildcards are involved is:

LIKE

i.e.

name not like "UNNAMED%"

HTH

Dave
At 04:38 PM 09/10/2000, you wrote:
>Greetings List
>
>I've been tring to create an expression that would label a streams layer
>with only valid names ("Mapinfo Creek" "Mapbasic Pond" and not "UNNAMED
>STREAM"  "UNNAMED POND" etc), using the following string:
>
>Name <> any("UNNAMED%")
>or
>Name <> "UNNAMED%"
>
>But the labels only produce "T" I assume for "True"
>
>What am I doing wrong?
>
>Thanks
>dave
>
>----------------------------------------------------------------------
>To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
>"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]


                     David L. Dennis
SOFPREP Support Manager       Phone:  (904) 881-2312
TYBRIN Corporation                     DSN: 641-2312
[EMAIL PROTECTED]            FAX:    (904) 881-4985

----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]

Reply via email to