Remove single quote

[andoid95]

Hello,

I have one column in list Report Name [path]. When I run Report [path] show me

1. content/folder[@name='HK loc report']/folder[@name='Russia']/report[@name='rep' ]
2. content/folder[@name='HK local report']/folder[@name='Russia']/folder[@name='Mosc ou'/report[@name='rep']

Now I want to replace this single quote (') by ('') in path because I want to use the replace function after.

[bdbits]

I think the replace function would work (depending on database vendor as it is not a native function). You have to double up the quotes in the strings, so it looks a little odd. Try this:

replace([path],'''', '''''')