Another option is to use TRY_CONVERT() if you want to make sure it'll actually convert to something in SQL server 

select 'yes'
where TRY_CONVERT(decimal(29, 9), @SearchVal) IS NOT NULL