Re: formating output

2004-09-17 Thread Jim Grill
> 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 -00-00 then just show a blank > b) for a phone number o

formating output

2004-09-16 Thread Donna Hinshaw
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 -00-00 then just show a blank b) for a phone number of 99