[EMAIL PROTECTED] wrote:
Hi,
I have a query that returns a list of numbers ranging from -10 to +10
I would like to be able to have a 2nd column where a result of 5 is 5
but -5 is also 5, so in effect all the negative (and only the negative)
results are made positive to find the deviation from zero.
ABS(column) ?
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, September 01, 2004 6:59 AM
Subject: A question of negative numbers..
Hi,
I have a query that returns a list of numbers ranging from -10 to +10
I would like to be able to have a 2nd col
<[EMAIL PROTECTED]> wrote on 01/09/2004 11:59:58:
> is there a function to make negative
> numbers positive?
ABS(x)
See http://dev.mysql.com/doc/mysql/en/Mathematical_functions.html
Alec
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Found answer to my own question:
Returns the absolute value of X:
mysql> SELECT ABS(2);
-> 2
mysql> SELECT ABS(-32);
-> 32
This function is safe to use with BIGINT values.
MySQL Reference Manual (C) 2002 MySQL AB
abs()
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, September 01, 2004 12:59 PM
Subject: A question of negative numbers..
Hi,
I have a query that returns a list of numbers ranging from -10 to +10
I would like to be able to have a 2nd column whe