>Hi All,
>
>I know how to force Currency in a SQL statement:

>SELECT $1 * Get_Age() AS Currency_Age FROM ...

(And NO I wouldn't want a Currency Age <bg>)
>
>I can't figure out how to get Integer instead of Numeric.
>
>Any Ideas?
>TIA,

Hi Bill,

Trying to find the thread, I searched through all my 673 messages and get rid off some of them. Anyway, finally I found thread by searching on Gar Lipov.
Databases,Tables, Views, Indexing and SQL syntax Re: Create an Integer field on the fly Thread #382290

Hope this helps.