That will work, but keep in mind that then you are dealing with a string, and not a number. Data formatting should be left to the user interface. It does not normally fall under the scope of the database server in application design.
If it's not practically useful, then it's practically useless.
Actually I have learned a few new things by goingthrough the replies but am not sure how to apply the suggested solution to my actual problem. Please bear with me :embarrassed:
My original SQL is below:
and I want the result to be displayed in comman format with 2 decimal places. How do i re-write the above SQL using the suggested convert function to get the desired result. If this helps, the datatype for my qty column is float(8).