Subject RE: [IBDI] SQL Help
Author Claudio Valderrama C.
> -----Original Message-----
> From: Charlie [mailto:charliekerscher@...]
> Sent: Domingo 18 de Marzo de 2001 13:02
>
> I'm using Delphi 5, Interbase 6. I have an Items table that has
> widthstring and heightstring as fields. The client's business
> rules require that the widthstring and heightstring be rounded to
> the next integer; so 12.5 would become 13.

This is not a support list. However, your issue is easily resolved: just use
CAST. Example:
select CAST(12.5 as integer) from...
gives 13
select CAST(12.55 as numeric(9,1)) from...
gives 12.6

C.