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(dot)klaver(at)aklaver(dot)com