On 8/14/21 9:14 AM, Bret Stern wrote:
I have a table with metric, imperial, fraction columns.
Is there a way to sort correctly using imperial (eg; .125, .375, .437 ->
1., 1.125)
Alright how is this different from metric or fraction?
I can sort of see fraction if you mean as 1/3, 1/20, etc.
What is the data type of the field you are storing this in?
Couldn't handle it with ORDER BY ASC, DESC args so I added a sort_column
and sorted based
on those values eg; 1,2,3,4,5,6 indicating the value I need to show in
which sequence.
Just curious what the pro's do
Bret
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
