UK Post code Area

• MMartin1

  One Orange Chip

  Points: 27795

  More actions

  January 27, 2015 at 11:48 am

  #1773464

  I thought something like the following may be helpful as well , based on your requirements of course...

  select postalCode = Case when patindex('%[0-9]%',postalcode) > 0

  Then left(postalCode, patindex( '%[0-9]%',postalCode)-1)

  Else postalCode

  END

  From yourTable;

  ----------------------------------------------------