Vyper wrote:Did my suggestion do what you wanted regarding the word 'the'?
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…
UPDATE Songs SET Artist= Replace(Artist, ' the ', ' The ') WHERE Artist glob "* & the *" OR Artist glob "* and the *"
Users browsing this forum: No registered users and 16 guests