Question on Rounding Issue

Hi,
I have a stored procedure that is passed a decimal value like 2.5 and it is
rounding it to 3. Why is this? I have tried using a float and decimal as
the type and it still is rounding it up or down. Any ideas?
@.pipeOD float or @.pipeOD decimal
SELECT * FROM fsupport WHERE fsize = @.sSize AND fmodel = @.model AND fmat =
@.material AND fsize = @.size AND @.pipeOD
BETWEEN flpipeod AND fupipeodI figuered it out. I needed to do this:
@.pipeOD decimal(5,3)
Thanks
"Tim" <Tim@.noemail.net> wrote in message
news:O7vfQFYKFHA.1280@.TK2MSFTNGP09.phx.gbl...
> Hi,
> I have a stored procedure that is passed a decimal value like 2.5 and it
> is rounding it to 3. Why is this? I have tried using a float and decimal
> as the type and it still is rounding it up or down. Any ideas?
> @.pipeOD float or @.pipeOD decimal
> SELECT * FROM fsupport WHERE fsize = @.sSize AND fmodel = @.model AND fmat =
> @.material AND fsize = @.size AND @.pipeOD
> BETWEEN flpipeod AND fupipeod
>
>