Comparing Numbers – Number Difference 2

[Accel45]

I am attempting to create a query that shows the number of digits between two numbers.
The problem I am having is with negative numbers and sorting.

This what I am getting (Sort on Difference)
BaseNumber - OtherNumber = Difference
75 76 -1
75 75 0
75 74 1
75 70 5

This is what I want to get (Sort on Difference)
BaseNumber - OtherNumber = Difference
75 75 0
75 76 1
75 74 1
75 70 5

Looking for Suggestions on how to accomplish this.

Accel45

 

[SkipVought]

Hi,
Try the ABS (absolute) function

Skip,

_{[red]Be advised:[/red] The dyslexic, agnostic, insomniac, lays awake all night wondering...
"Is there really a DOG?"}

 

[RoyVidar]

ABS function

[tt]differense: abs(BaseNumber - OtherNumber)[/tt]

Roy-Vidar