How to modify a record

Hi everybody...

I need to modify record.pls tell me how....

Please be more specific!

However you can modify a record like this using SQL:

UPDATE (tablename) SET (column_name) = '(Original_Name)' WHERE (column_name) = '(New_Name)';

The pieces in brackets you'll have to replace with something of your own. This will modify ALL the records whose names are Original_Name and change the name to New_Name

-------------------------
Alex
(http://www.alex-greg.co.uk)

Actually, Alex, you got that backwards. The way you have written the query it will change column_name to original_name where column_name = new_name

Let's say that you have a table called "table1", which has a column called "column1".

In this column you want to update all rows containing the value "Value1" in "column1" to contain the value "Value2"

UPDATE table1 SET column1='Value2' WHERE column1='Value1';

Kelvin

[This message has been edited by releasedj (edited June 21, 2000).]

how if the value we going to change is a string...