Hi there

I'm sure that there is a very simple answer to this syntax error but can anyone tell me what I have to do to rectify it?

UPDATE testing
SET dummy1 = camilla AND
 dummy2 = camilla2
AND dummy3 = huntw
WHERE dummyID = 1

Incorrect syntax near the word AND

Many thanks

Adam

UPDATE testing
SET dummy1 = 'camilla' AND
 dummy2 = 'camilla2'
AND dummy3 = 'huntw'
WHERE dummyID = 1

If dummyID is text type than u have to use WHERE dummyID ='1'

...but the Soon is eclipsed by the Moon

oops, sorry I supposed SELECT instaed of UPDATE. Here is the correct statement:

UPDATE testing
SET dummy1 = 'camilla',dummy2 = 'camilla2', dummy3 = 'huntw'
WHERE dummyID = 1

...but the Soon is eclipsed by the Moon