Posted by Hugo Kornelis on 02/07/06 00:46

On Mon, 06 Feb 2006 17:50:01 +0200, David Greenberg wrote:

>Hi
>I have a character field, varchar(60), and I want to replace only a part
>of it, a set substring which is always in the same set positions.
>Does anyone have an Sql statement or algorithm/sp that could do that
>with one call or run ?
>Thanks
>David

Hi David,

Look up the STUFF function in Books Online - this will do exactly what
you want.

--
Hugo Kornelis, SQL Server MVP

[Back to original message]