You could cast directly to numeric (8,3)
Cast (my_value as numeric (8,3)

Regards,
PaulM

-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Marc Heath @ MWEB
Sent: Tuesday, April 11, 2006 10:54 AM
To: firebird-support@yahoogroups.com
Subject: [firebird-support]

Hi ,



I've CAST a double precision to a VARCHAR. This gives me a result of
15.180000000

I'd like to format the string to be displayed as 15.180



Thanks



[Non-text portions of this message have been removed]



++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://firebird.sourceforge.net and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Yahoo! Groups Links