On 2007-01-31 [EMAIL PROTECTED] wrote: > Can anyone point me to a section of manual or link how to reduce digits
Lookup the manual for "round()" but be sure that you understand it if you use round in financial applications as it might be unexpected for you: mysql> SELECT 25E-1 = 2.5, round(25E-1, 0), round(2.5,0); +-------------+-----------------+--------------+ | 25E-1 = 2.5 | round(25E-1, 0) | round(2.5,0) | +-------------+-----------------+--------------+ | 1 | 2 | 3 | +-------------+-----------------+--------------+ 1 row in set (0.00 sec) > "Also could someone give a hint how to recode digits in order to anonymize > data." Depending on what exactly you want, play around with random() and substring(). bye, -christian- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]