Try ABS()
Terry
--Original Message-
Hi all,
I m looking for any function or a work around to fetch numerical data
without its sign (-10 --10, 10 -- 10). Any ideas?
Thanx
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Hi all,
I m looking for any function or a work around to fetch numerical data without its sign
(-10 -- 10, 10 -- 10). Any ideas?
Thanx
On Mon, Feb 02, 2004 at 07:16:13PM +0530, Nitin Mehta wrote:
Hi all,
I m looking for any function or a work around to fetch numerical data without its
sign (-10 -- 10, 10 -- 10). Any ideas?
ABS() :
mysql select abs(-10);
+--+
| abs(-10) |
+--+
| 10 |
+--+
Nitin Mehta [EMAIL PROTECTED] wrote:
Hi all,
I m looking for any function or a work around to fetch numerical data without its
sign (-10 -- 10, 10 -- 10). Any ideas?
There is ABS() function in MySQL:
http://www.mysql.com/doc/en/Mathematical_functions.html
--
For technical support