[sqlite] Good way for CEIL, or is there a better way

[OBones]

Cecil Westerhof wrote:
> I need to have a CEIL function in SQLite. This is the way I implemented it:
> WITH percentage AS (
>      SELECT date
>      ,           100.0 * rank / outOf         AS percentage
>      ,      CAST(100.0 * rank / outOf AS int) AS castedPercentage
>      FROM ranking
> )
> SELECT date
> ,      (CASE WHEN percentage = castedPercentage
>             THEN castedPercentage
>             ELSE castedPercentage + 1
>         END) AS percentage
> FROM percentage
>
> Is this a good way, or is there a better way?
Isn't Ceil(Value) simply Round(Value + 0.5) ?