Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 115
  • Last Modified:

Convert money to nchar

Hi,


How to convert   3.1E+50  to  nvarchar

strInfield = 3.10000000000000000000000000000000000000000000000000000

 MyMoney = Convert.ToDouble(strInfield)

Now ,  mymoney = 3.1E+50
How to convert it to nvarchar


Cheers!
0
RIAS
Asked:
RIAS
  • 2
  • 2
1 Solution
 
AndyAinscowCommented:
The strinfield is a string, in other words an nvarchar.  No conversion required.
0
 
RIASAuthor Commented:
It does need Andy in the sql stored procedure
0
 
AndyAinscowCommented:
It should not need converting.  At the most it might need truncating to fit the nvarchar.

If you want to convert a double to a string then
str = d.ToString(supply the format you want if default format is not suficient)
0
 
RIASAuthor Commented:
Cheers!
0

Featured Post

Granular recovery for Microsoft Exchange

With Veeam Explorer for Microsoft Exchange you can choose the Exchange Servers and restore points you’re interested in, and Veeam Explorer will present the contents of those mailbox stores for browsing, searching and exporting.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now