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" --- test case --- create temp table temp_x (a,b); insert into temp_x values ("foo/bar",1); select a,b from temp_x where replace(a,"/","-") <> "foo-bar"; --- error message --- error: 1 - no such function: replace(1) at dbdimp.c line 271 select a,b from temp_x where replace(a,"/","-") <> "foo-bar" ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
