Home Forums SQL Server 2008 SQL Server Newbies Explanation of LIKE '%[0-9]%'? RE: Explanation of LIKE '%[0-9]%'?

  • July 29, 2013 at 6:20 am

    #1636603

    Solomon Rutzky (7/27/2013)

  • 23847234872893475983479583749583749573945739 is all digits, is a valid number, but is NOT convertible to any SQL Server number types as it is larger than 38 digits

    • ...

    You can convert it to float (with lose of some precision ;-))

    select cast('23847234872893475983479583749583749573945739' as float)

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]