>I have the following situation. In some of my computation I will arrive at a result of say 9.975. However I do not want to round up but want to place only the 9.97 in my table. However if I have define the table as two decimals point is automatically round it up to 9.98.
You can force truncation using the FLOOR() function. To force truncation at 2 decimal places, use:
FLOOR(nNumericExpn*100)/100