reformatting floats ?

["Gauthier, Dave" <dave.gauthier@xxxxxxxxx>]

Hi:

 

if...  

create table coords (id int, x float, y float);

then... 

insert into coords (id,x,y) values (1,1.000,2.001)

and then...

            select * from coords

i get...

            1,1,2.001

i want...

            1.1.000,2.001

while retaining the numeric nature of the x,y data (for math ops in other operations).

 

How can I reformat the float output (sort of like using “%5.3f” in good-ole C)

 

Thanks !