Subject Re: [firebird-support] How to add empty space into between characters in string?
Author Anderson Farias
Post date 2009-09-02T11:29:33Z
Hi,


> Hi all, I use FB 2.1.3 RC2, I have a string(Ex: ABCD), I want to add an
>empty space(or an character ‘,’) between each characters in string. Please
>send me what function or SQL code.

Use SUBSTRING , ex:

select substring(yourfield from 1 for 1)||','||substring(yourfield from 2
for 1) from yourtable



Regards,
Anderson