[AccessD] Update Table

Try this:

UPDATE [tablename] SET [fieldname] = '0' & '[value]' WHERE
((Len([fieldname])=5));

-Christopher-

---- Original Message ----
From: Oleg_123 at xuppa.com
To: accessd at databaseadvisors.com, 
Subject: RE: [AccessD] Update Table
Date: Thu, 30 Oct 2003 16:54:56 -0500 (EST)

>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
>
>
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com
>