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 | +----------+ -- Chris -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]