Update Query

[matthewR]

I have a table that has a field "Region (By Cl County)" that has some data that needs changed. Some of the data should be "CR - Middle Market Central" but the data is showing "CR ? Middle Market Central". I want to change all the data that says "CR ? Middle Market Central" to "CR - Middle Market Central". How would I do this in an update query? Thanks for your help.

[HansV]

You could use the Replace dialog, but if you prefer to use an update query:

UPDATE [tblData] SET [Region (By Cl County)] = "CR - Middle Market Central"
WHERE [Region (By Cl County)]="CR ? Middle Market Central"

where tblData is the name of the table.

[Timelord]

update tablename set region = replace
(region, 'CR ? Middle Market Central','CR - Middle Market Central')

[matthewR]

Thank you. I used the GUI and put
Like * CR ? Middle Market Central" in the criteria
and
CR - Middle Market Central in the Update to

[HansV]

That should work, but be aware that it would also change "CR A Middle Market Central" or "CR 9 Middle Market Central" (or any character in place of ?) to "CR - Middle Market Central".

(Probably not a real problem)