Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: STUFF command

Re: STUFF command

From: Brian Peasland <dba_at_remove_spam.peasland.com>
Date: Wed, 31 Mar 2004 15:16:54 GMT
Message-ID: <406AE0E6.69A13E3E@remove_spam.peasland.com>


Jim Kennedy wrote:
>
> <grille11_at_yahoo.com> wrote in message
> news:c4e6ad$k1n$1_at_reader1.imaginet.fr...
> > Hello,
> >
> > I am trying to find the equivalent of the STUFF command from SQL (deletes
> a
> > 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
> characters
> > 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.
> Jim

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.

Cheers,
Brian

-- 
===================================================================

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 - 09:16:54 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US