Thanks - I've tested this on a database of 1.8 million postcodes and it seems the short-circuit approach is enough to stop this problem happening on my data:

IF ((@lat1 =...

I'm having a problem with this function.

I find that in some situations, I get an error: "An invalid floating point operation occurred."

This is true for instance, in *some* (not all)...