locked
error converting varchar to numeric data type RRS feed

  • Question

  • hello 

    I am trying to use this query to convert varchar to numeric datatype

    INSERT WSP.DBO.CLASSTYPE

     (CLASSTYPEID, AGENCYID, CREATEUSERID) 

     SELECT CONVERT(NUMERIC(10,0), C_CLASS_ID) AS CLASSTYPEID, A_AGENCY_ID, CREATED_BY FROM WSPC.dbo.A_CLASS_APPTS

    I am getting this error

    Msg 8114, Level 16, State 5, Line 1

    Error converting data type varchar to numeric.

    At the source there is varchar(8)

    Please help me asap

    Thanks


    dimrd_SQL
    Monday, December 20, 2010 3:49 PM

Answers

All replies