Re: [sqlite] Replace one string with another, in SELECT output

On 1/6/07, T&B <[EMAIL PROTECTED]> wrote: Hi All, Can I, within SQLite output (eg a SELECT statement) replace all occurrences of string 1 with string 2? Not easily. This is typically done after you get the results or by writing a custom user function. -- -- The PixAddixImage Collector suite:

[sqlite] Replace one string with another, in SELECT output

Hi All, 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,