Home Forums SQL Server 2008 SQL Server 2008 - General Looking for way to dynamically replace street suffix with abbreviation based on tables RE: Looking for way to dynamically replace street suffix with abbreviation based on tables

  • October 21, 2016 at 9:28 pm

    #1908145

    @jeff.Born,

    The list you have looks a bit familiar. Are you, by any chance, using the tables from the USPS? I ask because I went through this very same thing just a couple of months ago and may have a nasty fast solution but first want to compare my solution with some of the others posted here. I just need to know if you're using the USPS tables for this type of stuff to do my tests with because those are what I used.

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