Basit Khan

Basit Khan

  • NA
  • 336
  • 121.8k

Item Avg Unit Price numeric(18,4)

Dec 6 2016 11:17 AM
Hi,
 
I have Item Master the fields are
 
Itm_No numeric(18, 0)
Itm_Code nvarchar(50)
Itm_Desc nvarchar(500)
Itm_UnitPrice numeric(18, 4)
 
the data's are
 
 
 
100001111HP Laptop14.3310
200001112Dell Laptop14.3541
300001113samsung14.1000
 
what i want only take the exact decimal place.
 
100001111HP Laptop14.331
200001112Dell Laptop14.3541
300001113samsung14.1
 
Thanks
Basit. 

Answers (2)