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
[email protected]
http://www.directionsmag.com/mailman/listinfo/mapinfo-l

Reply via email to