Hi Ewout,

You can use the LEFT operator to cut off the extra characters:

     UPDATE MyTable SET MyColumn = LEFT(MyColumn, 6)


This will cut off the contents of the column MyColum to a length of 6. 
Shorter columns are ignored.

HtH

Imar


At 10:31 AM 9/29/2002 +0000, you wrote:
>Hello everyone,
>
>I have the problem that I have an 8 digit number that needs to become a 6
>digit number (the last two numbers need to be taken off)...how do I do
>this with an update Query? The field value is VarChar....
>
>Yours Truly
>
>Ewout