T&B <list.sql-s/[EMAIL PROTECTED]> wrote:
Can I, within SQLite output (eg a SELECT statement) replace all
occurrences of string 1 with string 2? For instance, if in the
Description column output I want to change any occurrence of
"string1" to "string2", can it be done? I imagine something like:
SELECT Replace(Description, 'string1', 'string2') FROM MyTable
Write and register Replace as a custom function.
Igor Tandetnik
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------