Converting Float to Int

[Former Member]

HI,

How could I convert float value to Int and pass ? I am using UDF ..

Eg:

11:9999999 I want to pass 12, Its a run time Program so dont know how the value would be...

Is there any function to round it off?

Thanks

Rajeev

[Former Member]

Hi Rajeev,

In your scenario there is no need to use UDF,there is CEIL an arithmatic standard function which u can use for this.

function of ceil is as the name conveys to ceil the number to nearest integer.

i.e; if the num is 7.89 ceil( 7.87) is 8 and ceil (-7.89) is 6.

regards,

prasad.k