Thanks for the response Brucevde.

Will try your suggestion for Part 1.

as for Part2
What happens is for ex: the the value to be printed is 7.70 I get 7.7 printed if I do not use the format function in the select statement.

I would like to print x.xx (7.70) if the value ends in zero. If it's 7.75 it will print as 7.75. Hope you understand what I' tryin to accomplish. And again thanks for responding.