Subject RE: [firebird-support] String replace?
Author Sasha Matijasic
>
> How do i perform a string replace in DSQL in Firebird 2.1?
>
> I mean something like this:
>
> Original string: 'This is some text'
> Replace s with _ and get this: 'Thi_ i_ _ome text'
>
> I can accept a function that only replaces the first occurrence if only
> such exist.
>

Surprisingly enough, there is a function called replace.
Look at the docs "README.builtin_functions.txt for syntax.

Sasha