Hi! The SQL below might be out there but I didn't find it and since there might be other that need to get 32-bit integer IP in a sqlite3 database to the a.b.c.d format using SQL
I did get started from http://acidlab.sourceforge.net/acid_faq.html#faq_e1 and for me what's below does the trick in sqlite3 :-) SELECT CAST((intIP & 4278190080) >> 24 AS text)||'.'|| CAST((intIP & 16711680) >> 16 AS text)||'.'|| CAST((intIP & 65280) >> 8 AS text)||'.'|| CAST((intIP & 255) AS text) AS strIP FROM IP_table; Cheers Roger _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
