Nothing built-in. Either write your own UDF,
or write Stored Procedure, or do it on client application.

Ivan

(What is ascii 9827 ??)

----- Original Message -----
From: "rodbracher" <rod@...>
To: <firebird-support@yahoogroups.com>
Sent: Wednesday, May 04, 2005 10:49 AM
Subject: [firebird-support] Inserting a character in place of another


> Hi
>
> Anyone know of a function that would replace one charater with another
> if the given char exists (in an update statement)
>
> Basically I need to replace all spaces with ascii_char(xxx) for a
> given column.
>
> E.g. '8 100' should become '8♣100'
>
> Thanks
>
> Rod