• MickyT, can you explain

    UPDATE POSTCODESTEST SET Location = Geography::Point(Latitude, longitude, 4326)

    especially 4326, also how to convert your code into a working SP please