> hi there...what function shall i use if i want to return a numeric data upto two decimal places only without rounding it off...for example i have 6.778, i want to return only 6.77
INT(YourNumber*100)/100. You can also check FLOOR function to see which suits you better.
Regards
Tushar