I have a table with a column called "weight" thatis a text field, but in this case, contains float values,such as ".8" or "0.25". Might also be null.
How can I sort them in numeric order instead oftextual order? Thanks.