We often ask children what they want to be when they grow up. I have no idea what my answer was when I was a kid – some people have memories of wanting to be a doctor or fireman but I was in high school before I decided and then I changed my mind 100... Continue Reading →
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 →