if your column type is character,
Val(YourColumnName)
use Val function,
Select val(Columnname) "ColumnSorted" from Tablenamr order by col1 into Selection
best regards
----- Original Message -----
From: Morrier, Steve <[EMAIL PROTECTED]>
To: MapInfo List (E-mail) <[EMAIL PROTECTED]>
Sent: Thursday, April 26, 2001 9:45 PM
Subject: MI-L Sorting
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
Sorry,
I should have specified that I am sorting street files and the column
contains highways that must be displayed as numbers. So converting my field
from character to integer is not an option. Thanks for everyones help.
Steve
Original Question:
Is there any way to get MapInfo to sort numerically? i.e.
1,2,3,4,5,34,78,100
instead of 1,10, 100, 2, 20, etc...
_______________________________________________________________________
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, send e-mail to [EMAIL PROTECTED] and
put "unsubscribe MapInfo-L" in the message body.
_______________________________________________________________________
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, send e-mail to [EMAIL PROTECTED] and
put "unsubscribe MapInfo-L" in the message body.
