Re: [sqlite] replace function?

2007-05-15 Thread Jim Dodgen
that would make sence, thanks. Quoting Joe Wilson <[EMAIL PROTECTED]>: > No error when run with most recent SQLite. > replace() may not have existed in 3.3.7. > > --- Jim Dodgen <[EMAIL PROTECTED]> wrote: > > I get an error in version 3.3.7 when using the replace function as defined > here: > >

Re: [sqlite] replace function?

2007-05-15 Thread Joe Wilson
No error when run with most recent SQLite. replace() may not have existed in 3.3.7. --- Jim Dodgen <[EMAIL PROTECTED]> wrote: > I get an error in version 3.3.7 when using the replace function as defined > here: > > http://sqlite.org/lang_expr.html > > "replace(X,Y,Z) Return a string

[sqlite] replace function?

2007-05-14 Thread Jim Dodgen
I get an error in version 3.3.7 when using the replace function as defined here: http://sqlite.org/lang_expr.html "replace(X,Y,Z) Return a string formed by substituting string Z for every occurrance of string Y in string X. The BINARY collating sequence is used for comparison" ---