mlr wrote:Is there a way to mark “The” not to change to “the” in the following?
Adam and The Ants, Adele & The Raconteurs, Diana Ross & The Supremes…
Using the SQL Viewer addin, you could try:
- Code: Select all
UPDATE Songs SET Artist= Replace(Artist, ' the ', ' The ') WHERE Artist glob "* & the *" OR Artist glob "* and the *"
This will update other "the"s to The in any artist with "& the" or "and the" so if someone had the name "For the Laughs and the Giraffes" it would become "For The Laughs and The Giraffes" but there can't be too many examples like that. (Treat with caution - I've not tried this!)