Post reply

Error while converting varchar to numeric

  • September 12, 2012 at 10:37 pm

    #266561

    Below is the query which is giving the error:---

    SELECT [Working ISIN], convert(decimal(18,3),[Split Old Paidup]) as [Split Old Paidup]

    , convert(decimal(18,3),[Split New Paidup]) as [Split New Paidup]

    FROM abc.[xyz].dbo.[lmn]

    Please help is required

  • September 13, 2012 at 1:50 am

    #1537043

    one of the two columns or both being converting to decimal have none transformable charcters, check the data and update/delete the offending rows.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply