Posted by gondar |
Filed under sql server, convert, format, money, price
credits: http://articles.techrepublic.com.com/5100-10878_11-5803705.html
in the select statment change the price column for:
CONVERT(varchar, CONVERT(money, YourFieldName), 1) + ' €'
and when you bind the query/procedure/view, it will return the value already formated
hope it helps :)
3c855477-a156-4682-81b1-f5676aee5850|0|.0