Hi gurus.

Need your help.

I have a sql server table with a few fields already populated, I have a text file that I need to read , the txt file has a field named Doc, I need to read the line whic I have no problem and find the same doc on the sql table and add something to a field on the same row.

How can I accomplish this is sql.- Is there such a thing as select- where and then insert on the same statement.

Thanks a bunch Gurus.