Q: format for convert

[Guest]

Hello,

SELECT name + ‘- ‘ + CONVERT(varchar,amt) as ddlCap from myTable

How can I get amt be like “#0.00†format in ddlCap?

 

[Guest]

This is SQL Server iisue, not asp.net! Wrong group.

 

[Karl Seguin]

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!)