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 !