LEFT Tag Archives

Learn how to Work Joins and Messy Data

In this puzzle, we’re going to learn how to join dirty data using SQL Server.  Many times you’re forced to use someone else’s data.  Since it is their system and data, not yours, you can’t always fix the inconsistently formatted data before it is in the database. So how can you use it?  Do this […]

Continue reading

Introduction to SQL Server’s Common String Functions

The built in SQL String functions make it possible for you to find and alter text values, such as VARCHAR and CHAR datatypes, in SQLServer.  Using these functions you can alter a text value such as changing “Smith, Joe” to “Joe Smith.” If you not familiar with SQL functions, then I would recommend staring with […]

Continue reading

Use SQL Server to Sort Alphanumeric Values

Sort Alphanumeric Values with SQL Server Recently a reader asked me how to sort an alpha numeric field in SQL in natural order.  Alphanumeric values are commonly found and don’t sort naturally using numeric methods. When we have a numeric fields we expect values to be sorted in ordinal order, for example: 1,2,5,7,10,11,15,20,21 However when […]

Continue reading