WD10: Alphanumeric sort of a query

Hi,

I have a file with a numeric value which I want to retrieve by an query sorted alphanumeric on the numeric value. So the order should be '1', '11', '12', '2', etc. instead of 1, 2, 11, 12. I use HyperFile and the problem now is that HF (WD10) does not support the sql STR() statement. How can I get the records on alphanumeric order without changing the filedefinition in the analysis ?

Stefan,

in WD 12 you can use the WL-keyword for using WL-language in querys. I don't know about WD10.
SELECT wl.NumToString(Field) FROM table
SELECT Task.Caption FROM Task WHERE WL.DateDifference(Task.StartTime, Task.EndDate) > 5

Arie

Hi Arie,

thanks for your response, but WD10 does not support WL-statements in queries, so I cannot use that.