[thelist] magnitude function in MySQL ?

[Means, Eric D]

>  -----Original Message-----
> From: 	Bigpant [mailto:bigpant at btinternet.com]
> Sent:	Tuesday, June 18, 2002 8:44 AM
> To:	thelist at lists.evolt.org
> Subject:	[thelist] magnitude function in MySQL ?
>
> Is there a function in MySQL that returns the magnitude of a number - ie
> removing the sign?

SELECT ABS(mycolumn) FROM mytable