[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 528
  • Last Modified:

Sorting sorting numbrer so that they are put in numerical order regardless if they are positive or negative numbers.

I have a column of numbers in a table (Acess 2003) that I need to sort in order by the number itself ingoring the positive or negative factor
example

52.00
(16.58)
(3.00)
15.00

the results would put the numbers in the  following order
(3.00)
15.00
(16.58)
52.00

Any idea how to do this.





0
NLGroup
Asked:
NLGroup
  • 2
1 Solution
 
Patrick MatthewsCommented:
SELECT *
FROM SomeTable
ORDER BY Abs(SomeColumn) ASC
0
 
jerryb30Commented:
Order by abs(yourValue) ascending
0
 
NLGroupAuthor Commented:
Sorry I forgot to mention that it needs to keep the positive and negative features of the numbers as well.

0
 
Patrick MatthewsCommented:
NLGroup said:
>>Sorry I forgot to mention that it needs to keep the positive and negative features of the numbers as well.

Both of our suggestions do that.  They really are the same suggestion, when you get down to it...
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now