Replace in 2007

  • Thread starter Thread starter Mapping
  • Start date Start date
M

Mapping

I upgraded from 2000 to 2007 and I have an update query that I cannot edit.
In 2000 it was : Replace([tblHyperlinkUpd].[TR_ELCO],"M:","#M:")
2007 changed it to :Replace([tblHyperlinkUpd].[TR_ELCO]|"M:"|"#M:") 2007
changed the , to |. Now I can't change the | back to a , . Any ideas?
 
I discovered that I had changed the language settings from comma to a pipe
under control panel, Regional and Language Options.
 
Back
Top