Simple Update Query

[guygodwin]

This is what I have and it is not working. I am not sure what the correct syntax should be.



Table name = SkpiUpdate
Field = NAMC

I have several records that have "04" listed. I would like to updated these 04 fields with the accronym "TMMMS".

My current not good code:
UPDATE SkpiUpdate SET SkpiUpdate.NAMC = if(NAMC='04',TMMMS,NAMC);

Any help on the proper Syntax would be great.

[pbaldy]

It would need to be:

UPDATE SkpiUpdate SET SkpiUpdate.NAMC = iif(NAMC='04',"TMMMS",NAMC)

But more efficient would be:

UPDATE SkpiUpdate SET SkpiUpdate.NAMC = "TMMMS"
WHERE NAMC='04'