I am using bcp to insert data into a table. For just one column, i am getting NULL values as character 'NULL'. How can we deal with it ? I was checking in MS site and it gives one -k option which specifies that "empty columns should retain a null value during the operation, rather than have any default values for the columns inserted".
However I'm looking for a solution where the NULL should be treated as NULL value and not 'NULL' string for just one column. Can anyone suggest what to do ?