That's great mickyT, thank you and everyone else for your help in this as well as your patience

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

Sorry MickyT, I didn't see your post before posting, you're solution works, many thanks

I've now changed @radius type to float and now I get

Msg 8115, Level 16, State 2, Line 5

Arithmetic overflow error...

Yes, both Latitude and longitude

Thanks, but now I'm getting a different error : -

Msg 8115, Level 16, State 2, Line 5

Arithmetic overflow error converting expression to data type float.

my actual query is :...

Many thanks for the info, the thing is I can't get the code to work, when I paste it into the query analyser it reports the following error message

Incorrect syntax...

Many thanks Luis, all helps with my learning of SQL

That is excellant, thank you so much Michael

Sorry I've only just replied to your posts as I've been on leave. the reason it was only 50 on my example is that it was an existing SP which...

thanks Jeff, it's not something I've used before. What is the advantage? and can the table created be read using VB.net?

Thanks again Tom, this project is part of a VB.Net project to get a random x amount of postcodes from an SQL Server table and insert the records into...

As Tom suggests, temp tables seem not to work so I've created and dropped a normal table, I've posted my complete code below incase it'll help anyone else.

USE [misc]

GO

/****** Object:...

Thanks Keith, that works a treat

Thanks again