Dave,
I think you have found the right method, but you might not be able to sort by an _expression_ directly, so you would need to add the _expression_ to the list of columns to select and then order by this new column.
Select LOTNBR, Val(LOTNBR) "LOTNBR_VAL"
From LOTS
Order By LOTNBR_VAL
Peter Horsbøll Møller
GIS Developer, MTM
Geographical Information & IT
COWI A/S
Odensevej 95
DK-5260 Odense S.
Denmark
Tel +45 6311 4900
Direct +45 6311 4908
Mob +45 5156 1045
Fax +45 6311 4949
E-mail [EMAIL PROTECTED]
http://www.cowi.dk/gis
"For enden af regnbuen..." - hvordan kommer man dertil og er det overhovedet muligt?
Læs mere om årets MapInfo konference på www.cowi.dk/mapinfokonference
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of David Reid
Sent: Friday, July 28, 2006 5:45 AM
To: MapInfo-L@lists.directionsmag.com
Subject: [MI-L] Sorting records by val of a character formatted column
Greetings List,
I have a parcel table with the field [LOTNBR] formatted as "Character"
Naturally when sorted you get:
1
10
11
12
2
20
21 etc etc
I've tried using in the "sort" field val(LOTNBR) but to no avail to achieve:
1
2
3
4 etc
Anyone know the syntax to do this?
Thanks, Dave
--
Outgoing mail is certified Virus Free
Checked by AVG Free Edition.
Version: 7.1.394 / Virus Database: 268.10.4/401 - Release Date: 07/26/2006
_______________________________________________
MapInfo-L mailing list
MapInfo-L@lists.directionsmag.com
http://www.directionsmag.com/mailman/listinfo/mapinfo-l
_______________________________________________ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
