Subject | RE: [firebird-support] String replace? |
---|---|
Author | Pham Huu Le Quoc Phuc |
Post date | 2008-08-28T07:57:58Z |
Look at Doc folder in install. README.builtin_functions.txt, Look up REPLACE
function
_____
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Kjell Rilbe
Sent: Thursday, August 28, 2008 14:55
To: firebird-support@yahoogroups.com
Subject: [firebird-support] String replace?
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.
Thanks,
Kjell
--
--------------------------------------
Kjell Rilbe
DataDIA AB
E-post: kjell@datadia. <mailto:kjell%40datadia.se> se
Telefon: 08-761 06 55
Mobil: 0733-44 24 64
[Non-text portions of this message have been removed]
function
_____
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Kjell Rilbe
Sent: Thursday, August 28, 2008 14:55
To: firebird-support@yahoogroups.com
Subject: [firebird-support] String replace?
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.
Thanks,
Kjell
--
--------------------------------------
Kjell Rilbe
DataDIA AB
E-post: kjell@datadia. <mailto:kjell%40datadia.se> se
Telefon: 08-761 06 55
Mobil: 0733-44 24 64
[Non-text portions of this message have been removed]