While '||' is the standard, unfortunately MSSQL uses '+' for string concatentation so people that are used to using '+' are most likely coming from MSSQL and thus using '||' does not make for portable SQL (MSSQL does not support '||', at least not in version 2005).
In my applications I have a custom Concat() function to do string concatenation and then write an implementation of this in both SQLite and MSSQL so the same SQL can be run on both databases. Sam On Wed, Feb 27, 2008 at 2:48 AM, John Stanton <[EMAIL PROTECTED]> wrote: > > This is plain vanilla, standard SQL according to the standard. You will > find that Sqlite sticks to the standard quite well so if you write ANSI > SQL it is not only understood by Sqlite but be portable. > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
