Extracting a set amount of text from field in table

[nigel9097]

Hi,

Is there anyway of extracting a certain amount of text from one field to another in the same table.

I have a table called mainTable and in that table are two fields, one called detailDescription and another called thumbDescription.

I wish to copy the text out of mainDescription in to thumbDescription but only say the first 200 characters. Each detailDesciption is currently varying lengths and over 200 characters.

Is there any sql that could do that?

Regards,

Nigel

 

[dhookom]

Sounds like an update query. Back up your database file then

Update Maintable
SET thumbDescription = Left(mainDescription,200);

Duane
Hook'D on Access
MS Access MVP