I'm trying to run the following ACCESS query on a MS SQL Server box.
SELECT (abs(Sqr((([GRIDN]-43550)^2)+(([GRIDE]-43170)^2)))/100) AS TheDistance, *
It's complaining about the Sqr function.
Does this function exist ?
If not, how can this (Pythagora's) function be written ?
Will grade A for a quick accurate response.