SQL Server Function Bug Question

M

Mike Samyn

I hate to ask here but I'm hoping someone may know the answer.

In Access and Excel I had a function that would calculate something like this:

10^(-2.1152252) = 0.007669636 in Access 2000
10**(-2.1152252) = 0.007669636 in Excel
or
POWER(10,-2.1152252) = 0.007669636 also in Excel

In SQL Server User defined functions I can't seem to use ^ or ** and so I
attempted to use the POWER function like in Excel but it returns ZERO for the
same numbers.

Is this a bug or am I missing something? I've defined my input and outputs
as floats and reals with no change either way.

Thanks
Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

To SQL Expert: VBA Function that Calls SQL Query 3
Excell: VBA Function that Calls SQL Query 0
VBA Microsoft Access and SQL Server 1
XIRR vs. IRR Function 11
User defined function 10
Embedding excel formula in MS Query that will be evaluated in excelnot in the SQL server 0
User Defined Function Help 4
Linked SQL Tables don't report Cascading Updates and Deletes 2

Top