• WHERE @SearchVal NOT LIKE '%[^0-9.]%'
    AND LEN(@SearchVal) - LEN(REPLACE(@SearchVal,'.','')) < 2

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001