Unfortunately, I cannot see anything attached. Anyway, JPG is not very good idea for posting query plan. You better save it as XML. You need to post complete query if you want relevant help. Also, posting DDL of involved database objects would be helpful.
Okay will do thanks, the database is currently changing the datatype of the Field ID Number to numeric so I'll post it up when that's finished, but it might take a while to complete.
Edit: full query plan uploaded here: http://www.sqlservercentral.com/Forums/Attachment13640.aspx