Not sure why you'd do that in SQL. Consider pulling 2 separate columns,
Name and Amt (why abbreviate???) and let your presentation layer take care
of formatting.
(a)ASP.Net is much more capable of formatting than SQL
(b)It makes your query more reusable/flexible because it only pulls raw data
and can be formatted any way you want..
Karl
--
MY ASP.Net tutorials
http://www.openmymind.net/ - New and Improved (yes, the popup is
annoying)
http://www.openmymind.net/faq.aspx - unofficial newsgroup FAQ (more to
come!)
"JIM.H." <JI**@discussions.microsoft.com> wrote in message
news:3A**********************************@microsof t.com...
Hello,
SELECT name + '- ' + CONVERT(varchar,amt) as ddlCap from myTable
How can I get amt be like "#0.00" format in ddlCap?