Conversion issue when assigning smallmoney data type to varchar

• Manish Mittal

  SSC Veteran

  Points: 207

  More actions

  April 21, 2011 at 12:20 am

  #249574

  I have been facing a value truncation issue while storing smallmoney/float type value into varchar type. Seems implicit converison not working the way what expected. For example look at the below lines:

  Declare @V1 Varchar(10)

  Declare @V2 smallmoney

  Set @V2=1.12345

  Set @V1=@V2

  Print @V1

  Output:

  1.12

  While it should be 1.12345

  Please share your views on this.

• ModestyBlaise84

  SSCommitted

  Points: 1931

  More actions

  April 21, 2011 at 12:42 am

  #1314332

  believe that it is because of the following:

  Set @V1=@V2 is doing CAST. And for CAST and smallmoeny data type default is to show 2 decimal digits.

  If you do

  CONVERT (varchar(10),@V@,2)

  You should get 4 decimal digits.

  (2 is for the style of showing it)

  Also, smallmoney can have MAX 4 decimal digits, so you should either using some other type of have: Set @V2=1.1234

  Please check BOL for CAST and CONVERT

• Manish Mittal

  SSC Veteran

  Points: 207

  More actions

  April 21, 2011 at 1:22 am

  #1314338

  Thanks a lot.