Re: rounding

Sergio Gonzalez wrote:

> How can I round numbers inside a stored procedure?

	CAST AS INTEGER:

  MY_INT_VARIABLE = CAST (MY_DOUBLE_VARIABLE AS INTEGER);

-- 
Craig Stuntz [TeamB] · Vertex Systems Corp. · Columbus, OH
  Delphi/InterBase Weblog : http://blogs.teamb.com/craigstuntz
Please read and follow Borland's rules for the user of their 

Sergio Gonzalez wrote:

> So I can do the same with numerics?

	Yes. 

	That said, we define our own rounding proc, since we use a different
rounding method (more like a CEIL than a ROUND). See if the default
method fits your needs, and if not, write your own proc which uses
rounding to integer and multiplication to implement your own.

-- 
Craig Stuntz [TeamB] · Vertex Systems Corp. · Columbus, OH
  Delphi/InterBase Weblog : http://blogs.teamb.com/craigstuntz
Borland newsgroup denizen Sergio González has a new CD of 

Hello,
How can I round numbers inside a stored procedure?
Thanks in advance!
Sergio 

> CAST AS INTEGER:
>  MY_INT_VARIABLE = CAST (MY_DOUBLE_VARIABLE AS INTEGER);

Thanks Craig! So I can do the same with numerics?

MY_INT_VARIABLE = CAST (MY_DOUBLE_VARIABLE AS numeric(18,2));

I didn't know CAST would work outside a SELECT statement!