Empty fields and null values

• mrfleck

  Mr or Mrs. 500

  Points: 509

  More actions

  April 17, 2003 at 5:22 pm

  #105699

  This should be an easy one, but seems to be stumping me this afternoon. I have a textfile with several columns of numeric or blank values. The table allows ints or nulls only. So, these blank fields need to be changed to null values instead of copied directly. Is there an easy way to do this? The text file is tab delimited.

  Thanks!

• April 21, 2003 at 8:00 am

  This was removed by the editor as SPAM

• LeopoldNjampa

  SSC-Addicted

  Points: 473

  More actions

  April 28, 2003 at 6:29 am

  #455503

  Have you tried using BCP (cf. BOL) to import the file's data into a table and then updating the columns as required

  e.g. UPDATE TableName

  SET Col1 = null WHERE Col1 = ''