Need little help qith SQL query

[Pics Traffic]

I need to update few rows of data but only for range of entries with ID's between 40 and 100.
so
update table set field='blah-blah' where id ---- ???

[nnweb]

update table set field='blah blah' where id >= 40 and id <=100

[polle54]

update table set field='blah blah' where id >= 40 and id <=100

correct.

[Pics Traffic]

I kiss you.
Thanks

[rowan]

Try also

UPDATE table SET field='blah blah' WHERE id BETWEEN 40 AND 100