Space between characters

[lenygold via DBMonster.com]

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....m-db2/200804/1

[Dan van Ginhoven]

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@uwewrote in message news:837fb3b2f4e25@uwe...

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....m-db2/200804/1

[Dave Hughes]

lenygold via DBMonster.com wrote:

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.

The TRANSLATE function [1] can be handy for this:

VALUES TRANSLATE('A B C D E F G H', SOMESTRING, 'ABCDEFGH')

For example:

SELECT
TRANSLATE('A B C D E F G H', S, 'ABCDEFGH')
FROM (
VALUES
('ABCD'),
('1234'),
('Testing')
) AS T(S)

Outputs:
1
---------------
A B C D
1 2 3 4
T e s t i n g

3 record(s) selected.
Just expand the first and third parameters with more characters if
extra length is required.
[1]
http://publib.boulder.ibm.com/infoce.../com.ibm.db2.l
uw.sql.ref.doc/doc/r0000862.html
Cheers,

Dave.

[lenygold via DBMonster.com]

Thank you. Translate is working
Dave Hughes wrote:

>I HAVE A STRING: ABCDEFG

[quoted text clipped - 4 lines]

>>
Thank's in advance Leny G.

The TRANSLATE function [1] can be handy for this:

VALUES TRANSLATE('A B C D E F G H', SOMESTRING, 'ABCDEFGH')

For example:

SELECT
TRANSLATE('A B C D E F G H', S, 'ABCDEFGH')
FROM (
VALUES
('ABCD'),
('1234'),
('Testing')
) AS T(S)

Outputs:

1
---------------
A B C D
1 2 3 4
T e s t i n g

3 record(s) selected.

Just expand the first and third parameters with more characters if
extra length is required.

[1]
http://publib.boulder.ibm.com/infoce.../com.ibm.db2.l
uw.sql.ref.doc/doc/r0000862.html

Cheers,

Dave.

--
Message posted via http://www.dbmonster.com