update

[EscapeUK]

I have a table in the following format

ID_code Date cost
1000 01/01/2002 £3000
2000 02/01/2002 £3000
3000 03/01/2002 £4000
4000 05/02/2002 £3000
5000 05/02/2002 £2000
6000 06/02/2002 £1500
7000 07/02/2002 £3000

I would like to change the date to 10/04/2000 for call ID codes between 2000 and 6000

 

[lewisp]

UPDATE <table>
SET date = To_Date('10/04/2002','DD/MM/YYYY')
WHERE ID_Code BETWEEN 2000 AND 6000;