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 !