Square root command in SQL

[David Gartrell]

Hi there,

As part of an SQL query written in Access 2000, I need to be able calculate
the square root of a set of figures. Does anyone know whether there is a
square root command that can be used in SQL?

 

[Michel Walsh]

Hi,



Fieldname ^ 0.5


Hoping it may help,
Vanderghast, Access MVP

 

[Brian Camire]

Sqr([Your Field])

should also work.