Fred Williams wrote: > Would it not be more logical to modify the .import command to place a > null value in a column where the input value is non existent? (i.e. Back > to back separators in the input) Null in, null out.
Please don't do that. I have many databases with empty strings in them which are NOT nulls. Indeed, I have some databases where NULL and '' are supposed to be distinct values, with different meanings. -- Nikki Locke, Trumphurst Ltd. PC & Unix consultancy & programming http://www.trumphurst.com/ ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
