select cast('1234      ' as int);

select cast('1 234' as int);

select 
	isnumeric('1234     ') trailing_yep, 
	isnumeric('1 234') middle_nope;

trailing_yep middle_nope
------------ -----------
1            0

select cast('1 234' as int);

isnumeric('1.234,56')

isnumeric('1.234,56')

isnumeric('123,45.7')

isnumeric('12345.67,89')

 SELECT ISNUMERIC('1,2,3,4,5,6,7,8,9'),
        CAST('1,2,3,4,5,6,7,8,9' AS MONEY)