error

• Mike Levan

  SSChampion

  Points: 14201

  More actions

  December 6, 2007 at 9:20 am

  #62986

  Select jobid As job,

  CASE WHEN code in ('1','2','3') THEN code

  ELSE 'Code is wrong' End AS ErrorMessage

  FROM emp where job not in ('1','2','3')

  when i run the above sql statement I am gettign an error

  Msg 245, Level 16, State 1, Line 1

  Syntax error converting the varchar value 'Code is wrong' to a column of data type int.

• Ray M

  SSC-Insane

  Points: 21093

  More actions

  December 6, 2007 at 10:14 am

  #757761

  What data type is the code column in your emp table?

  Please Post table definition.

  It is likely your code table is an int.

  Try

  Select jobid As job,

  CASE WHEN code in ('1','2','3') THEN cast(code as varchar(12))

  ELSE 'Code is wrong' End AS ErrorMessage

  FROM emp where job not in ('1','2','3')