I believe this will work, but haven't tested it.
Update Table1 Set Table1.Field1 = Mid([Table1].[Field1], 5) & ", The" Where
Left([Table1].[Field1], 4) = "The "
Check the first 4 characters (including the space after the) so that you
don't also catch other words that begin with "the".
--
Wayne Morgan
MS Access MVP
"Soundneedle" <so*********@hotmail.com> wrote in message
news:11**********************@l41g2000cwc.googlegr oups.com...
I have a table (tbl_Titles) where several records (tbl_Titles.Title)
that start with "The ...". I'd like to convert this to "..., The".
How can this be done with an update query?