Hello,
When I declare a VB variable Dim s as Decimal,
I want to cast d like this :
1452,41
41,00
45,47
756544,04
Only with to digits after the ","
How can I perform this
Hi,
If my variable d=125,45111
How can I view d like 125,45 ?
|||you mean 2 digits after a "decimal" not a "comma" right?|||
You have two choices use place holder in strings and formatting or set precision and scale. Try the links below for details. Hope this helps.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconcustomnumericformatstringsoutputexample.asp
http://support.microsoft.com/?kbid=892406
|||
Hi,
If you are asking how to mak this conversion using t-sql, you can use CAST function
You can run and test the result for CAST
DECLARE @.d FLOAT
SET @.d = 125.45111
SELECT @.d, CAST(@.d AS DECIMAL(10,2))
Hi,
Thank I mean two digits after a decimal number ( 44,45 or 4,00 or 7888,01 )
I'm using VB.NET and my variable is declared like Dim x as decimal.
Thanks
No comments:
Post a Comment