SQL - Distance to nearest premise using lat/long

Hi all, I am looking to create a function that i can then use on two tables. The first with UPRN (unique premise ref.), Latitude and Longitude coordinates and type A. The second identical but of type...