Richard Klein wrote: > > One question: I thought that the '\' character is not part of the > SQL standard. (That's why I specified '/' instead as my ESCAPE > character). >
The '\' character is valid character in standard SQL. It just doesn't have the property of being an escape character as it does in C and mySQL (I believe). In standard SQL you have to explicitly say which character you want to use as an escape character using the escape clause. Any character will work. HTH Dennis Cote _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users