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@...> 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.firebirdsql.org 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
>
>
>
>