How to QQ::OrderBy alphanumeric

There is a way to order values in alpahnumeric order using QQ::OrderBy()?

With SQL syntax which worked for me:

SELECT * FROM table ORDER BY table.field+0;

Can anyone help me to implement this with QQ:Orderby()?

Thank you.

(I guess I messed up navigating tabs while answering... please ignore this post)

In that case I see only 2 options :
- Convert your field to integer so that it gets sorted on the numeric value

or

- Make sure your records all have the same lenght by adding leading zeros. You can run an update query to add leading zeros so that it gets sorted properly.

Does that make sense?

-patrick

Yeah, unfortunately QQ constructs do not support custom fields like this in the OrderBy clause... but in truth, I would strongly suggest that you reconsider your order-by column.  Having integers stored in a varchar that you specifically need to order against is not just a kludge, but it's quite inefficient from a performance standpoint.