Hi folks - I have looked thru the documentation and the books I have on MySQL - but have not found anything on how to format column output from select statements. I'm trying to do several things - a) if a date is the default of 0000-00-00 then just show a blank b) for a phone number of 9999999999, format the output as 999-999-9999 Hints?
thanks, "know how to do this in oracle, but in mysql ...?" Donna
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
