Hi Jason!
The first thing that comes to mind is the Val() function.
MB help says:
The Val( ) function returns a number based on the string_expr string _expression_. Val( ) ignores any white spaces (tabs, spaces, line feeds) at the start of the string_expr string, then tries to interpret the first character(s) as a numeric value. The Val( ) function then stops processing the string as soon as it finds a character that is not part of the number.
Caveat: if the digit is preceeded by a character, the function returns zero.
So if this is the case, you will need to do a step by step analysis of the string to weed out non-numeric characters and keep the rest, after which the above function can be used to convert the string to a numeric value.
Hälsning / Best regards Mats.E
________________________
FB Engineering AB
Södra Förstadsgatan 26
211 43 Malmö
Tel: 040-660 25 50
Mobil: 0705-27 60 27
Fax: 040-660 25 99
[EMAIL PROTECTED]
www.fbe.se
_______________________________________________ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
