Conversion failed when converting the varchar value

• pvc

  SSC Enthusiast

  Points: 123

  More actions

  December 30, 2008 at 8:07 am

  #133460

  SELECT FIELD1 + ' : ' + FIELD2 as CONCATSTRING

  FROM MYFILE

  returnes the floowing eror

  Conversion failed when converting the varchar value ' : ' to data type int.

  What is wrong ?

• ps.

  One Orange Chip

  Points: 29422

  More actions

  December 30, 2008 at 8:18 am

  #919068

  Duplicate Post. Pls reply to

  http://www.sqlservercentral.com/Forums/Topic627369-23-1.aspx

  ---

  
  Pradeep Singh