I have a load of hyperlinks in a table that point to documents on our server.
we have 2 domains at work so i need to ammend the prefix of the hyperlinks from...
I have written the following update query..
when I run the query i get the following error..Code:Update "Document Table" Set PathInformation = replace(pathinformation, "SERVER" , "SERVER.srl.local" Where PathInformation Like "%SERVER";
syntax error in query. Incomplete query clause
I can't see where I am going wrong, all the examples i can find on google show update/replace queries as i have written mine!
If anyone can point me in the right direction I will greatly appreciate it!!
Thanks in advance,