Home Forums SQL Server 2008 T-SQL (SS2K8) Non-Printable Character Detection RE: Non-Printable Character Detection

  • April 11, 2015 at 9:36 pm

    #1790370

    Ah crud. More coffee please. Thanks for the correction, Eirikur. You're absolutely correct about the dash.

    That also adds more functionality to the COLLATE because it will find only the exact characters according to a binary match instead of possibly finding accented characters, as well.

    --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)