Evaluating SQL Column Values as Formulas: Challenges and Alternatives

How to Create a Dynamic Suffix for an Address Column in SQL Server Using ROW_NUMBER()