I have a requirement to get the decimal value with no rounding for a comparision purpose.
when i use format and cast it is defaultly rounding.
Ex: if decimal value is 23.456, i need the output as 23.45 not as 23.46
Can any one help !!
Here are similar threads that will help you:
1)You may cast the value as character,take the 2 digits after decimal(use position,String length functions) and again cast back to decimal(18,2)