<div>
try this:<br />
<br />
select convert(DECIMAL(8,2),xyz,1<wbr />) from yourtable<br />
<br />
AW
</div>


try this:

select convert(DECIMAL(8,2),xyz,1) from yourtable

AW

<div>
it will not put the comma I mean 1000 seprator.
</div>


it will not put the comma I mean 1000 seprator.

<div>
how are you then displaying the data? &nbsp;Can you format the rsult, after the query executes, but BEFORE is is displayed?<br />
<br />
AW
</div>


how are you then displaying the data?  Can you format the rsult, after the query executes, but BEFORE is is displayed?

AW

<div>
I want to write a select query which give you the formated results.
</div>


I want to write a select query which give you the formated results.

<div>
Thanks, I need some function which format any kind of numeric data like as we use in vb format() any way thanks. I am accepting your answer but if you have or figure out pre build function then let me know.<br />
<br />
Thanks
</div>


Thanks, I need some function which format any kind of numeric data like as we use in vb format() any way thanks. I am accepting your answer but if you have or figure out pre build function then let me know.

Thanks

<div>
<div class="content wysiwyg-content">
Is there any way we can get the formated output in SQL Query Analyzer (SQL2K).<br />
<br />
for example Select format(&quot;###,###.00&quot;,xyz) from xyz
</div>
</div>


Is there any way we can get the formated output in SQL Query Analyzer (SQL2K).

for example Select format("###,###.00",xyz) from xyz

Number Format in SQL Query Analyzer

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.