Jacques,
How about:
Select * from table1 Where Str$(obj) = "Region"
To get the points, replace "Regions" with "Point", or "Polyline", etc...
Ken Fioretti
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Andy
> Sent: July 15, 1999 6:59 AM
> To: mapinfo mailing list
> Subject: MI Selecting using object type in an assorted table
>
>
> Imagine a table holding points, polylines and regions (polygons in the
> real world). Is there a one-stop method for sql selecting all the
> points, or all the lines etc..
>
> I can do it in a two-stop method; as below;
>
> Select id, obj from table1 into Selection
> Browse * From Selection
>
> and then;
>
> Select id from table1 into Selection
> Where table1.Object = "Point"
> Browse * From Selection
>
> A free rude joke (from Chad) to anyone who can come up with an answer
>
> regards,
> Andrew Bailey
>
>
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
