please help me with the below error in sql URGENT : 
while running the below query i am getting error for field error_num 

Implicit conversion from datatype 'VARCHAR' to 'INT' is not allowed.  Use the CONVERT function to run this query.

below is the query 

select top 100"Insert into KLG_TRN_SCE..dbBatchRequest values ('" 
 + comp_nr
+"','"
+ ssn_nr
+"','"
+ convert(char(10),Version,101)
+"','"
+ plan_nr
+"','1"
+"','"
+ CAST(LEFT(error_num, 4) AS int)
+"',"
+ error_txt
+"',"
+ addname
+"',"
+ convert(char(10),adddate,101)
+"')"
From KLG_TRN_SCE..dcErrorBin
Where ssn_nr='603761193'