• declare @SearchVal varchar(10) = '1234.00'

    select 'yes'
    where @SearchVal NOT LIKE '%[^0-9.]%'
        AND @SearchVal NOT LIKE '%.%.%'

    Drew

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA