update all records by 20% in a field 1

[Cpreston]

Hi

Simple one , or should be , but googled and cant quite find the syntax I need.

I have a table called, delivery and field called linecost. I need to update the line cost field by 20%

So if a cost was £20.00 after the update it should be £24.00
I have 211 rows to update so can use a where clause , but cant quite figure out how the formula

Update delivery
Set linecost = linecost !!!!!!!!
Where deliveryid = 300

This would update one so I know it works, its the !!!! part I cannot work out.

Any ideas please.

Thanks

 

[SkipVought]

Set linecost = linecost * 1.2

 

[Cpreston]

Thanks works well,
Many thanks