Thanks... I am getting correct results with this.

However can you please confirm the following:

round(26.153875,4,1)

so here

first of all round will take upto 4 digits after decimal,

next as we mentioned 1...

hi actually i had similar doubt ...

i am trying to insert data from A table to another B table

A table has a value 26.153875 (decimal field (28,6)

when i inserted...

MY DATA TYPE IS DECIMAL ONLY.

ACTUALLY WHAT I WANT IS, I DON'T WANT IT TO BE ROUNDED