Sort order string

[bodylojohn]

Hello,

I have a query containing a tekstfield called 'page'

Here are some values of the field 'page':

Page
-----
no page
33
2.2
2.1
5.6
no page
no page

when I sort my query on page it looks like this:"

Page
-----
2.1
2.2
33
5.6
no page
no page
no page

However...it should look like this:

Page
-----
2.1
2.2
5.6
33
no page
no page
no page

How can I achieve this?

 

[namliam]

iif(isnumeric(field),cdbl(field),9999999)

Should convert any number to a real number and make any non number 9,999,999 putting it at the end of the sort ...

Hope this helps you