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/infocenter/db2luw/v9r5/topic/com.ibm.db2.l
uw.sql.ref.doc/doc/r0000862.html
Cheers,
Dave.
|
