I declared a field as DECIMAL(19,6) when doing select thatfield from tb1 for some reason ODBC thinks that it is a double I think it has to be a string, otherwise precision is lost or am I not understanding this right? I tried to do select thefield\\:\\:varchar but for some reason that did not work yet. thanks in advance, Vlad -- V S P toreason@xxxxxxxxxxx -- http://www.fastmail.fm - Access your email from home and the web -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general