I get that it does not work and the work around is simple enough, I was just wondering if someone could explain why? I can't seem to find any...

I agree, and it doesn't ring "true" for me for some reason...

this works...

select CONVERT(float, '123.0')

so why doesn't...

select CONVERT(int, '123.0')

especially since MSSQL will convert a float of 123.456 to an int...

Yes, again thank you for the push in the right direction.

Thanks Gail, that pointed me in the right direction. Here is the result...

Error message in SQL Error Log:

SELECT failed because the following SET options have incorrect settings: 'ANSI_NULLS, QUOTED_IDENTIFIER'....