how to format price values ? directly in sql server

Posted by gondar | Filed under , , , ,

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