On 9/4/07, Mario Madunic <hajduk@xxxxxxxx> wrote:
>
> I'm trying to replace all ampersands in a string to 'and'. Long story short:
> XSLT counts length as 1 but SQL Server counts length as 5, so need to replace.
>
> I'm using XSLT2's replace function against a string but am having problems
> escaping the ampersand. I've tried various methods, but with no luck.
>
> replace($l_TempString, '\&amp;amp;', 'and')
>
> Any insight will be appreciated.

Isn't it just:

replace($l_TempString, '&amp;', 'and')

?

No need to escape it...

-- 
Andrew Welch
http://andrewjwelch.com
Kernow: http://kernowforsaxon.sf.net/