Archives of the TeradataForum

Message Posted: Fri, 16 May 2014 @ 12:18:35 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Thanks Marek. I believe ROUND is a UDF function which does not exist in our installation.

Any other thoughts?

I was thinking something like this -

     sel case
            when cast(15.67 as decimal(18,3)) mod cast(15.67 as integer) > 0
            then cast(15.67+1 as integer)
            else cast(15.67 as integer)
            end

But it doesnt work properly. Keeps returning 16 no matter what the values are after decimal.

Thanks

Debojit

	<Prev	Next>		<<First	<Prev	Next>	Last>>