SQL Server: Splitting Strings

Today I was asked how to extract the directional component from a street address. For example, the following 3 street addresses should have a directional value of 'East': E Street East Road Big River Blvd E My first approach was to do the old fashioned case statement. Select street_address , case when address like 'E%'... Continue Reading →

Powered by WordPress.com.

Up ↑