Home Forums SQL Server 7,2000 T-SQL UK Post code Area RE: UK Post code Area

  • January 26, 2015 at 7:30 am

    #1773102

    LEFT(Postcode,PATINDEX('%[^A-Za-z]%',Postcode+'0')-1)

    Far away is close at hand in the images of elsewhere.
    Anon.