[thelist] magnitude function in MySQL ?

[Bigpant]

Lovely, that's the one. Thanks.
Phil

------------------------------------------------------------------------
---------
Phil Parker
Web Developer
Paragon Communications Ltd
Tel: 01296 330099 / 01262 424299
Email: PhilParker.DNS at btinternet.com
Disclaimer:
The information in this email is confidential and is intended solely for
the use of the addressee. If you are not the intended recipient of this
email you have received it in error and any disclosure, copying or
distribution is strictly prohibited.
When addressed to our customers, this email is subject to Paragon
Communications Limited terms and conditions. Any views or opinions
expressed by the author of this email do not necessarily represent those
of Paragon Communications Limited.


-----Original Message-----
From: thelist-admin at lists.evolt.org
[mailto:thelist-admin at lists.evolt.org] On Behalf Of Means, Eric D
Sent: 18 June 2002 14:48
To: 'thelist at lists.evolt.org'
Subject: RE: [thelist] magnitude function in MySQL ?

>  -----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
--
For unsubscribe and other options, including
the Tip Harvester and archive of thelist go to:
http://lists.evolt.org Workers of the Web, evolt !