Snippet:

DECLARE VARIABLE I INTEGER;
DECLARE VARIABLE N INTEGER;
DECLARE VARIABLE C CHAR;
BEGIN

I = 1;
N = STRLEN(NAME);
DEBLANKED_NAME = '';

WHILE (I <= N) DO
BEGIN
C = SUBSTR (PROD_NAME,I,I);
IF (C <> ' ') THEN
DEBLANKED_NAME = DEBLANKED_NAME || C;

I = I + 1;
END

----- Original Message -----
From: "Yosvany Llerena Rguez" <pfi_yerena@...>
To: <firebird-support@yahoogroups.com>
Sent: Tuesday, May 24, 2005 5:23 PM
Subject: [firebird-support] delete space (' ') in string field


> hi, all.
>
> I need to delete all the spaces (' ') character between words in a
> varchar()
> field.... May I do this?, How?
>
> for example: I need to transform this text 'Action [ 50 : 45 ]; Legal [
> 90 ]' into 'Action[50:45];Legal[90]' without spaces
>
> best regards.
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>
>