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:
[font="Tahoma"]I love deadlines. I like the whooshing sound they make as they fly by. -Douglas Adams[/font]