From: Kevin P. <KPr...@gl...> - 2008-01-02 22:01:23
|
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 |