Help with sql set?

[Visslan]

I want to change dealerid to 3 for every dealer with a contract id = 3. I'm getting an error near '=' ? I don't know what's wrong? Thanks for help!

select * from contract where contractid = 15 set dealerid = 3

[TechGnome]

your SQL clauses are out of order.. it should read

UPDATE contract
set dealerid = 3
where contractid = 15


-tg