SQL Set Multiple Set Query

Hello,
I'm using the following SET query which works perfectly
UPDATE [Data] SET [Action]="Query" WHERE [Acc Num]=230061;

But now I want to change it so it updates 4 fields in one go, tried the following but it doesn't
work, any ideas?

UPDATE [Data] SET [Action]="Query" AND [Comments]="test" AND [Promise Payments]="0.00" AND [Date]=date() WHERE [AccNum]=230061;

Thanks
ShockUKAsked:
Who is Participating?
 
chaitu chaituCommented:
UPDATE [Data] SET [Action]="Query" , [Comments]="test" , [Promise Payments]="0.00" , [Date]=date() WHERE [AccNum]=230061;
0
 
tigin44Commented:
UPDATE [Data]
SET [Action]="Query" , [Comments]="test" , [Promise Payments]="0.00" , [Date]=date()
WHERE [AccNum]=230061;
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.