Hi!
If you have a fixed number of characters you can use
INSERT(INSERT(INSERT(INSERT(INSERT(INSERT('ABCDEFG',2,0,' '),4,0,'
'),6,0,' '),8,0,' '),10,0,' '),12,0,' ')
else you will want a stored procedure or UDF looping over the length of
the string doing for instance an insert
/dg
"lenygold via DBMonster.com" <u41482@[EMAIL PROTECTED]
> wrote in message
news:837fb3b2f4e25@[EMAIL PROTECTED]
> I HAVE A STRING: ABCDEFG
>
> HOW TO INSERT A SPACE BETWEEN ALL CHARACTERS?
> REQUESTED OUTPUT:
>
> A B C D E F G
>
> Thank's in advance Leny G.
>
> --
> Message posted via DBMonster.com
> http://www.dbmonster.com/Uwe/Forums.aspx/ibm-db2/200804/1
>
|
