[SQL] ROUND function ??

[Saurabh Mittal]

Hi,   select ROUND(0.5) ; returns 0 select ROUND(1.5) ; returns 2; select ROUND(2.5) ; returns 2; select ROUND(3.5) ; returns 4;....so on . I'm sure you would have figured out what's happening !!! Why ?? How do I get to approximate any number x.5 as x+1 ??   Saurabh