• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 101
  • Last Modified:

SQL Statement

What does "*" in below statement "BaseAmount=BaseAmount*-1"  mean ?


update SALES_INVOICE set BaseAmount=BaseAmount*-1
where  COMPANY='LEEJ'
 AND ACCOUNTNUM='81200810'
0
AXISHK
Asked:
AXISHK
2 Solutions
 
GaryCommented:
Makes no sense!
0
 
Johny BravoCommented:
If your BaseAmount is 5000
then executing above statement will make it, -5000

In short it is like (YourColumnValue) * (-1)
So if your BaseAmount value is 5000 it will work as (5000) * (-1) = -5000
0
 
PortletPaulCommented:
It means multiply

* is multiply

The update statement is reversing the sign of the values by multiplying everything by minus one:
if something was a positive number before the update it is negative after the update, and if negative before the update it will be positive after the update.
0
 
AXISHKAuthor Commented:
Tks
0

Featured Post

Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now