Easy SQL question

Posted on 2008-11-05
Medium Priority
Last Modified: 2010-03-20
I have a real easy one. I nee the SQL syntax to update the msrp field. I want it to be 110% of the price field.

update dyndns.items
set msrp = "price * 1.10"
where id=45274

Open in new window

Question by:patGRFXS
LVL 143

Accepted Solution

Guy Hengel [angelIII / a3] earned 200 total points
ID: 22890778
indeed easy
update dyndns.items
set msrp = price * 1.10
where id=45274

Open in new window

LVL 41

Expert Comment

ID: 22963977
you may need to use cast/convert function depending on the data type of your msrp and price fields.
update dyndns.items set msrp = price * 1.10 where id=45274  

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I'm trying, I really am. But I've seen so many wrong approaches involving date(time) boundaries I despair about my inability to explain it. I've seen quite a few recently that define a non-leap year as 364 days, or 366 days and the list goes on. …
Composite queries are used to retrieve the results from joining multiple queries after applying any filters. UNION, INTERSECT, MINUS, and UNION ALL are some of the operators used to get certain desired results.​
Loops Section Overview
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question