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

  • July 29, 2013 at 8:53 am

    #1636677

    Eugene Elutin (7/29/2013)

    Jeff Moden (7/29/2013)

    Eugene Elutin (7/29/2013)

    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)

    Considering that FLOAT only has 15 digits of precision, it'll be a pretty big loss. 🙂

    I wouldn't call 1.32% a such "big loss" :hehe:

    However you are right! It does depend! If this loss constitutes my interest in £ - I would probably die from heart-attack 😀

    Heh... absolutely agreed but wasn't talking about the loss in "value" of the number. Was talking about the number of digits that would be lost when trying to determine if a long string could be checked for "IsAllDigits".

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)