Converting varchar value late to data type int

• jrw39

  Mr or Mrs. 500

  Points: 565

  More actions

  August 20, 2009 at 12:04 pm

  #209798

  I am getting this error when I'm trying to run a sql script that I'm converting from access 07. The column in the table that i'm trying to update is a text field and should either have Late or remain blank.

  here's a line of the code in question

  CASE WHEN [SH Arv D Loc Date] > [End Date] THEN 'Late' ELSE 0 END AS LTLOT

  Msg 245, Level 16, State 1, Line 1

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

• matt6288

  SSCertifiable

  Points: 5058

  More actions

  August 20, 2009 at 12:22 pm

  #1042340

  You have the else clause using an integer. Try something like this.

  CASE WHEN [SH Arv D Loc Date] > [End Date] THEN 'Late' ELSE '' END AS LTLOT