By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,939 Members | 1,621 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,939 IT Pros & Developers. It's quick & easy.

Title with "The" in the beginning

P: n/a
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?

Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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?

Nov 13 '05 #2

P: n/a
Thanks Wayne! I'll work with that....

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.