Thanks Igor. It is working now. I seem to have made a mistake earlier with the brackets and pipes and quotes and ampersands ... Sorry the trouble.
dbikash. Igor Tandetnik wrote: > > "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 > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > -- View this message in context: http://www.nabble.com/Convert-integer-IP-address-to-string-IP-address-in-Sqlite-tp20267362p20303143.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
