<div>
The <a href="http://msdn.microsoft.com/en-us/library/a4ke8e73.aspx" rel="ugc">ABS command</a> will change it from negative to positive. &nbsp;Remove the ABS and you should be okay.<br />
<br />
<i>lsTotalPrice = CStr(System.Math.(System.M<wbr />ath.Round(<wbr />lnTotalPri<wbr />ce, 2))) </i>
</div>


The ABS command [http://msdn.microsoft.com/en-us/library/a4ke8e73.aspx] will change it from negative to positive.  Remove the ABS and you should be okay.

lsTotalPrice = CStr(System.Math.(System.Math.Round(lnTotalPrice, 2)))

<div>
There is an error when I remove the ABS.<br />
<br />
It says &quot;Identifier expected&quot;.<br />
<br />
Thank you.
</div>


There is an error when I remove the ABS.

It says "Identifier expected".

Thank you.

<div>
In what way is it not working? &nbsp;The &quot;Identifier expected&quot; problem should be resolved...
</div>


In what way is it not working?  The "Identifier expected" problem should be resolved...

<div>
Try this<br />
lsTotalPrice=CStr( (System.Math.Round(lnTotal<wbr />Price, 2)))
</div>


Try this
lsTotalPrice=CStr( (System.Math.Round(lnTotalPrice, 2)))

<div>
@Paulmacd:<br />
<br />
You are right. It was my end. <br />
<br />
Thank you for your help.
</div>


@Paulmacd:

You are right. It was my end.

Thank you for your help.

<div>
Happy to help. &nbsp;Thanks for the points!
</div>


<div>
<div class="content wysiwyg-content">
I am trying to import using 2010 VB.net and SQL 2008 R2 to text file but for a negative numbers it defaults to positive as an output when imported. <br />
<br />
I have been trying to search but no luck.<br />
<br />
2010 VB.net:<br />
<br />
<br />

<pre><code id="code-10-28597653-1"> lsTotalPrice = CStr(System.Math.Abs((System.Math.Round(lnTotalPrice, 2)))) </code></pre>
<br />
Example:<br />
SQL Table column is <br />
<br />
Total Price: <br />
-105.10(Negative)<br />
<br />
Text file:<br />
It displays as output is <br />
105.10(Positive)<br />
<br />
<br />
Any help is much appreciated.<br />
<br />
Thank you.
</div>
</div>


I am trying to import using 2010 VB.net and SQL 2008 R2 to text file but for a negative numbers it defaults to positive as an output when imported. 

I have been trying to search but no luck.

2010 VB.net:


(CODE)

Example:
SQL Table column is 

Total Price: 
-105.10(Negative)

Text file:
It displays as output is 
105.10(Positive)


Any help is much appreciated.

Thank you.

Convert negative output in 2010 VB.net

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

Microsoft Applications

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.