TRY_CONVERT large numbers

  • stephen.long.1

    SSCrazy

    Points: 2577

    Hugo Kornelis (3/5/2016)


    MMartin1 (3/4/2016)


    I wonder why int to varchar was special.

    I am sure that sometime, somewhere deep in the dark and muddy past of SQL Server (probably back in the Sybase days), someone had a compelling argument for this.

    I am not going to speculate on this one, though!

    I think the "blame" for this is on Microsoft.

    When I try the following in Sybase (Adaptive Server Enterprise 15.7), I get an error:

    SELECT CONVERT(VARCHAR(1), 234523)

    ERROR: Insufficient result space for explicit conversion of INT

    value '234523' to a VARCHAR field.

Viewing post 31 (of 31 total)

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