I'm trying to clean up some data in Access 2000, so I want to capture anything 'like' a string of text and update it. There are going to be 30 variations of below so I'm storing them in a module rather than writing a bunch of separate queries; I just need to know what's wrong with WHERE statement that gives me the syntax error:
Public Sub doUpdates()
Dim mysql As String
mysql = "UPDATE tblTerritory_AnalysisFINAL " & _
"SET tblTerritory_AnalysisFINAL.Terr_Name = 'Health Insurance'" & _
"WHERE tblTerritory_AnalysisFINAL.Terr_Name= LIKE '*Health Insurance*'"