much obliged.



----- Original Message ----
From: Fabiano Bonin <fabiano@...>
To: firebird-support@yahoogroups.com
Sent: Tuesday, July 8, 2008 3:54:19 PM
Subject: Re: [firebird-support] Replacing Special Characters


Yes, you can use REPLACE function (FB 2.1). In this example i replace
CR+LF for "\n"

select replace(a.rdb$ description, ascii_char(10) || ascii_char(13) ,
'\n') from rdb$database a

On Tue, Jul 8, 2008 at 3:34 PM, slalom91 <slalom91@yahoo. com> wrote:
> I have an issue where carriage return / line feeds are existing in a
> field within one of my tables. This is a result of copy / paste
> routine on a web page. Are there any built in routines in Firebird to
> replace characters in a string? Ideally, I could add this logic to a
> trigger on the affected table.
>
>
> ------------ --------- --------- ------
>
> ++++++++++++ +++++++++ +++++++++ +++++++++ +++++++++ +++++++++ +++++++++
>
> Visit http://www.firebird sql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoeni x.com
>
> ++++++++++++ +++++++++ +++++++++ +++++++++ +++++++++ +++++++++ +++++++++
> Yahoo! Groups Links
>
>
>
>


[Non-text portions of this message have been removed]