Thanks Fernando,

I failed to mention I was working with SQL Server 6.5 which does not appear to support this command.

-Isaac

>you can use the REPLACE command for this
>
>REPLACE('expresiónCadena1', 'expresiónCadena2', 'expresiónCadena3')
>
>SELECT REPLACE('abcdefghicde','cde','xxx')
>
>GO
>
>
>
>Éste es el conjunto de resultados:
>
>------------------------------------------------------------------------
>
>abxxxfghixxx
>
>(1 row(s) affected)