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

• Next in forum: Re: Any T-SQL advice?
• Prev in forum: Re: Monthly date range substitution
• Thread view: Re: how do i replace a substring in sqlserver ?

[Reply to this message]