Sorting an SQL query

[nexturejohn]

Hi, in a LibreOffice query, I wish to sort a table whose first column contains 1,2,10,20,100,200,1000,2000. I want the result to be 1,10,100,2,20,200, 1000, 2000.
This is what I tried. Can you help please?

SELECT “tbl_ACSE”.“VOL”, “tbl_ACSE”.“FOTO” FROM “tbl_ACSE” WHERE ( “tbl_ACSE”.“FOTO” = 1 ) ORDER BY SUBSTRING ( “tbl_ACSE”.“VOL”, 1, 3)
thanks

[Villeroy]

http://www.hsqldb.org/doc/1.8/guide/ch09.html#N1251E
Try ORDER B CAST(“VOL” AS CHAR(3))

[nexturejohn]

thanks! Works fine