select '¥'+convert(nvarchar,cast('12434545.9462' as money),1) 如有更好的高招请不吝赐教. 原文出自: Bestcomy.net blog 转载于:https://www.cnblogs.com/puke/archive/2007/06/14/783589.html