I'd like to know that a NULL is going to be inserted into a non-nullable field on one row via RAISEERROR, skip that row's update, and then allow the SQL statement to continue.

I want to update a value in a table in a SQL Server Db with a value from one of the fields in the text file. I want to do this based on a query using the second field in the text file.