You are right. But it is very special.

select cast(cast('5.67' as real) as int)
select cast(cast('5' as real) as int)
select cast(cast('-' as real) as int)


The first two will work. Last one does work.


Thanks


Jim