sql server 2000 functions "floor" and "ceil" 1

[tempo1]

Hi everyone,
I tried

floor(5/2)

and recieved 2 which is satisfactory.
But i also tried

ciel(5/2)

and got an unsatisfactory error message saying
that

'ceil' is not a recognized function name.

.
Can any one show me what i should write instead of "ciel" to get "up rounded" number ?
Thanks

 

[Crowley16]

erm, ceiling...?

--------------------
Procrastinate Now!

 

[tempo1]

yepp...
but something happens:
floor(5/2) yields "2" as well as ceiling(5/2). How do i write it to get 3 ?
Thanks

 

[ca8msm]

Run this:

SELECT 5 / 2

and then read this (specifically the results type section):

http://msdn2.microsoft.com/en-us/library/aa276874(sql.80).aspx

____________________________________________________________
Mark,
[URL unfurl="true"]http://aspnetlibrary.com[/url]

Need help finding an answer? Try the Search Facility or read FAQ222-2244.

 

[ca8msm]

Also, try running this after you have read the article:

SELECT CEILING(CAST(5 AS DECIMAL) / CAST(2 AS DECIMAL))

____________________________________________________________
Mark,
[URL unfurl="true"]http://aspnetlibrary.com[/url]

Need help finding an answer? Try the Search Facility or read FAQ222-2244.

 

[Crowley16]

5/2 is integer division, so result is actually 2

5.0/2.0 will give you a result of 2.5 and thus the correct ceiling result...

--------------------
Procrastinate Now!

 

[tempo1]

Thanks a lot crowley16.
You were very helpful.