[AccessD] Update Table

Hi Group

I need to update a column by setting all fields that are 5 characters long
to equal the same values pluls "0" at the beginning. How do I specify that
in WHERE ?


UPDATE GPM_1
SET [Org Level 2 Code]= "0" & [Org Level 2 Code]
WHERE





-----------------------------------------
Get Breaking News from CNN, ABC, NBC, CBS Now.
http://www.xuppa.com/news/?link=webmail