How to display integer value from numeric data

• DURGESH-769360

  SSC Eights!

  Points: 968

  More actions

  September 6, 2009 at 10:39 pm

  #74097

  Hi all,

  I need the output as follows

  col1 col2

  ---- ----

  val11

  val22

  val34

  val41.3

  val55

  val61.5

  wherein my col2 is of type numeric

  can anybody help me to solve this issue

  Regards

  Durgesh J

• arun.sas

  SSChampion

  Points: 11831

  More actions

  September 6, 2009 at 11:38 pm

  #1049984

  Hi,

  The 1.5, 1.3 is the Integer (whole number)?

  Use the ROUND OFF Method.

  Round (col2, 1)

• mahaboobvali.shaik

  Grasshopper

  Points: 21

  More actions

  May 13, 2012 at 10:43 pm

  #1486927

  hiii