How to sort/filter on measurements of different scale?
How to sort/filter on measurements of different scale?

Hey guys, I'm just getting started with datatables. On this table I have, data is stored in text like "5 metres", "50 centimetres", etc. How can I get this to work with sorting and filtering?
Do I have to change the data in the database, or are there any alternatives?
This discussion has been closed.