Sorting numbers text as numbers

[markl]

I want to create a report that uses a field that is a text field.

I would like to be able to sort it so that anything that looks like a number is sorted as a number (similar to what Excel does)

Thanks

Markl

 

[Manturo]

Try in your by statement the Integer function. It has worked for me.

Example:
for each TABLE no-lock by int(text_number field).