Greetings,

Very simple guys:

X = 2.000
X = 2.001
X = 2.356
X = 2.899

1st X should return 2, all others should return 3.
What is the dynamic function to make this happen?

Thanks, Don


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

You can probably use the following example:

create table ##round
(input decimal(10,3))

insert into ##round
values (2.000)
insert into ##round
values (2.001)
insert into ##round
values (2.356)
insert into ##round
values (2.899)

select Input, case ((convert(decimal(10,3), (cast(Input as
int)+1)))-Input) when 1.000 then ROUND(Input, 0) else (cast
(Input as int)+1) end Output
from ##round

drop table ##round


Edgardo Valdez
MCSD, MCDBA, MCSE, MCP+I
http://www.edgardovaldez.us/

Take a look at the Ceiling function - it returns the
smallest integer equal to or greater than the value.
You would just use:
SELECT CEILING(X)
FROM YourTable

-Sue

On Fri, 03 Oct 2003 13:14:50 -0700, don larry
<donlarry17 (AT) hotmail (DOT) com> wrote:

Thank you so much Edgardo , Sue..

The ceiling function is exactly what i wanted!

Don


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!