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

  • I know you are trying to replace full values with abbreviations and probably have good reasons to do this. However, if this was my system I would be looking to replace abbreviations with full values, particularly if it ends up as public facing data.

    Using abbreviations can look like you are penny pinching and willing to take short cuts in other areas. For me, showing a name in full shows respect, and helps give the impression you will show similar respect in other areas. It is nothing to do with the data, or the storage space it takes, it is an emotional or cultural thing.

    If your address data covers multiple countries, then you will hopefully have already found that abbreviations that are acceptable in one country are not correct in a different country. For example, in the UK although Rd, St, Av or Ave are recognised abbreviations for Road, Street, Avenue, they are rarely used in addressed mail. All the commercial address de-duplication systems I know of for UK addresses share the same concept of a correct address as one that does not have abbreviations.

    In most of Germany, the abbreviation Str is recognised and often used in preference to the full word Straße but both are acceptable, while in Switzerland the full word Strasse is preferred over Str. Germans prefer the spelling Straße to Strasse, while the Swiss people I know very much prefer Strasse over Straße.

    Standardising and de-duplicating addresses is important, but how you do it will without doubt impact the way your customers view your company.

    Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.

    When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara