Hi, I'm using this mysql select statement to have credits for a course which are in the database as 30 be divide by 10 to show up correctly as 3, it returns the number as 3.00, would anyone know how to get it to return the number as 3.0 and drop the second zero? SELECT num_credits/10 FROM course WHERE c_code='$course' Thanks : )