[pilot-db-list] sort text as numbers

[Kevin P. <KPr...@gl...>]

Does anyone know if there is a way to sort text as numbers in palm db?
For example, I have a field that is a text string field of room numbers,
ranging from 1-30or so, but sometimes there might be a room named G11 or
something that's why it needs to be text. If I sort ascending, then it
sorts only the starting with 1s together, then the 2s together. Is there
a way to sort text as numbers, as you can in Excel or other apps?

=20

Thanks,

=20

Kevin