"dbikash" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > This is not working for me. I just get the first octet. > > (The concat function is also not supported?)
|| (two pipe characters) is a concatenation operator in SQL. That is, 'a' || 'b' = 'ab'. concat() function is not supported because it's not needed. How do you run the statement? Do you, by any chance, pass it unquoted to some program on a command line, where a pipe character might be interpreted specially? Or something along these lines? What does this statement produce: select 'a' || 'b', 'a' || 'b' = 'ab'; Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
