Clearing Field

Hi,

I want to remove all Data in one Field and insert in another Field of the same record.

For example:
Fields: Name, Street

At the moment:
NAME = Test
STREET = Teststreet

I want to make:
NAME = anothername
STREET should be empty

How can I do this.

At the moment I try

UPDATE table SET Name = 'anothername', Street = '' WHERE Name = 'Test'

But I get an error message.


Who can help me?

Thanx in advance

Karsten

Hi, try this:

UPDATE table
SET Name = 'anothername', Street =NULL
WHERE Name = 'Test'

Hope this helps,
Oleg.