Shoakat

shoakat · August 3rd, 2004, 11:03 AM

Hello Friends,]
I want to update multiple field names in the table.

I tried this
Update Table
Set FieldName = 'Africa'
Set FieldName ='12112'
where FieldName = 'eric'
It gives me an error. Can you please modify the code.
Thanks

stu9820 · August 3rd, 2004, 12:25 PM

Can you give the error message?

shoakat · August 3rd, 2004, 01:20 PM

i am using SQL server. THe error it gives is as follows
Incorrect syntax near '='

rajanikrishna · August 3rd, 2004, 08:23 PM

hi

Update Table Set FieldName='Africa' where FieldName='eric'

happygv · August 4th, 2004, 06:46 AM

Hi Shoakat,

You don't have to use SET for each COLUMNNAME, Replace the second SET with ,(COMMA)

Your code.

Code:

Update Table
Set FieldName = 'Africa' Set FieldName ='12112'
where FieldName = 'eric'

Modified code

Code:

Update Table
Set FieldName = 'Africa', FieldName ='12112'
where FieldName = 'eric'

Cheers!

_________________________
- Vijay G
Strive for Perfection