Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

To the Power of in MSDE "^"

Status
Not open for further replies.
dantheman688

dantheman688

Programmer
Apr 24, 2007
1
GB
Afternoon all,
I'm having great difficultly getting a calculation to work in MSDE.
The problem is with with the mathimatical power to known in SQL as ^

If in excel you do =10^2 you get 100
If in MSDE you do Select 10^2 you get 8

What am I doing wrong?
 
Sort by date Sort by votes
Use the Power function.

Code: 
[COLOR=blue]Select[/color] [COLOR=#FF00FF]Power[/color](10,2), [COLOR=#FF00FF]Power[/color](2, 8)

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom
 
Upvote 0 Downvote
The [!]^[/!] is a bitwise exclusive or function in SQLServer/MSDE.

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

grnzbra
  • Locked
  • Question
Is "IF EXISTS()..." better than "IF (SELECT COUNT...) > 0"
Replies
4
Views
1K
gmmastros
gmmastros
peac3
  • Locked
  • Question
fill the gap of hierarchy data
Replies
11
Views
379
Chris Miller
Chris Miller
grnzbra
  • Locked
  • Question
How Do I Add Column to Middle of Table
Replies
4
Views
342
BobSuruncle
BobSuruncle
leifoet
  • Locked
  • Question
How can I update the input of a form (rows and columns) to the database in one query ?
Replies
1
Views
147
Chris Miller
Chris Miller
grnzbra
  • Locked
  • Question
SELECT TOP 1 of Each of a Group
Replies
5
Views
172
grnzbra
grnzbra

Part and Inventory Search

Sponsor

Back
Top