When I .import a file into a table, || results in a value of '' for the data item. How can I get a NULL value stored? This also happens when the item is at the end (EOL) of the row. Currently, I: UPDATE table SET value=NULL where value='';
Ted --- ________________________________________________________________ 3.14159265358979323846264338327950 Let the spirit of pi spread 2884197169399375105820974944592307 all around the world! 8164062862089986280348253421170679 http://pi314.at PI VOBISCUM! ================================================================ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users