At 05:54 PM 11/04/2006, you wrote:

>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

Well, you could write a UDF for it.

Or simply cast the DP to numeric(18,3) instead of varchar.

./heLen