While I'm at it...
ROUND(X,D) and FORMAT(X,D) are quite similar, but they are in different places in the documentation. Why is FORMAT() placed under Miscellaneous functions? It seems to be just as mutch 'mathematical' as ROUND(), even if it returns a string... (All the 'mathematical functions' return a number, could this be the reason for the distinction...?) (And none of them works with a column as the D parameter...) -- Roger query --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php