Simon, Obviously I am not as well versed in sqlite as you are. I hate to hate myself, but am still continuing with reading somewhat ancient files into a somewhat cohorrent database.
Thanking you for your time and trouble, Matthew p.s. shame about the parsing of comma delimited files though. Goodnight. --- On Sat, 13/8/11, Simon Slavin <slav...@bigfraud.org> wrote: From: Simon Slavin <slav...@bigfraud.org> Subject: Re: [sqlite] null handling import To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> Date: Saturday, 13 August, 2011, 19:46 On 13 Aug 2011, at 7:05pm, matthew (matthew.jsoft) white wrote: > Didn't know about the "typeoff" function. Is this anything like the CAST sql >syntax or is it peculiar to sqlite? One of SQLite's built in functions: http://www.sqlite.org/lang_corefunc.html Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users