Re: STUFF command
Date: Wed, 31 Mar 2004 15:16:54 GMT
Jim Kennedy wrote:
> <grille11_at_yahoo.com> wrote in message
> > Hello,
> > I am trying to find the equivalent of the STUFF command from SQL (deletes
> > specified length of characters and inserts another set of characters at a
> > specified starting point).
> > Would someone knows this?
> > thanks in advance
> > This example returns a character string created by deleting three
> > from the first string (abcdef) starting at position 2 (at b) and inserting
> > the second string at the deletion point.
> > SELECT STUFF('abcdef', 2, 3, 'ijklmn')
> > GO
> > ---------
> > aijklmnef
> Stuff is not a standard (AFAIK) of SQL (Structured Query Language). If you
> mean MS SQLServer SQL then that is a different story.
He did mean from MS SQL Server. I'm assuming this because the text and the example is cut and paste, word for word, from Books Online.
-- =================================================================== Brian Peasland dba_at_remove_spam.peasland.com Remove the "remove_spam." from the email address to email me. "I can give it to you cheap, quick, and good. Now pick two out of the three"Received on Wed Mar 31 2004 - 17:16:54 CEST