Error converting data type varchar to numeric.

• Papillon-395933

  SSC Veteran

  Points: 293

  More actions

  June 27, 2007 at 12:08 am

  #179238

  Hi

   

  Please help me out

  declare @CID numeric(3,0)

  set @CID = 121

  SELECT *

  from Table_name

  where ID Like ''''+@CID+'%'''

  I am getting error like

  Msg 8114, Level 16, State 5, Line 3

  Error converting data type varchar to numeric.

   

  T.I.A

• Sugesh Kumar

  One Orange Chip

  Points: 27311

  More actions

  June 27, 2007 at 12:45 am

  #715438

  chane the datatype of @CID to varchar and that should solve your problem.

  Cheers,
  Sugeshkumar Rajendran
  SQL Server MVP
  http://sugeshkr.blogspot.com