I agree with the above post, integer is very specific, in fact forget the odd character, even select convert(int,'0.0') will not work. select convert(decimal(2,1),'0,.0') will give the error that was supplied as one of the answers to the question.

Interestingly (or not, it is Friday lunch time), money to int will work no worries, rounding to the nearest int, so select convert(int,convert(money,'0,.0')) will work fine if you're worried about isnumeric letting you down! :hehe: