Update with replace query help

[goomba79]

Hello,



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...
\\server
to
\\server.srl.local

I have written the following update query..

Update "Document Table"
Set PathInformation = replace(pathinformation, "SERVER" , "SERVER.srl.local"
Where PathInformation Like "%SERVER";

when I run the query i get the following error..

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,

Iain

[orange]

Update "Document Table"
Set PathInformation = replace(pathinformation, "SERVER" , "SERVER.srl.local")
Where PathInformation Like "%SERVER";

Missing a closing )

[goomba79]

Update "Document Table"
Set PathInformation = replace(pathinformation, "SERVER" , "SERVER.srl.local")
Where PathInformation Like "%SERVER";

Missing a closing )

Hello!
thanks for replying!!
i have put the closing bracket in but still get a syntax error?

[orange]

Try this

Update [Document Table]
Set PathInformation = replace(pathinformation, "SERVER" , "SERVER.srl.local")
Where PathInformation Like "%SERVER";


You should not use spaces or special characters in field and object names.

[goomba79]

Try this

Update [Document Table]
Set PathInformation = replace(pathinformation, "SERVER" , "SERVER.srl.local")
Where PathInformation Like "%SERVER";


You should not use spaces or special characters in field and object names.

Yeah that's got it going!
i know about it being bad practice to have spaces in table/field names but unfortunately I inherited the database along with all the mistakes made!