Re: STUFF command

I'm not sure if this will do it, but the Oracle translate function does something similar to this. You might check that out.

Mark Simmons
Sr. Oracle DBA
Sabre-Holdings, Southlake, TX

<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
Received on Wed Mar 31 2004 - 13:23:31 CST