• (Bob Brown) (8/21/2012)


    Try this one: SELECT 1+'130'+'120'+1. It comes up 252! Implicit conversion are very dangerous.

    I would expect it to.

    1 + '130' = 131 ('130' converted to int)

    + '120' = 251 ('120' converted to int because the result above is an int)

    + 1 = 252 🙂



    --Mark Tassin
    MCITP - SQL Server DBA
    Proud member of the Anti-RBAR alliance.
    For help with Performance click this link[/url]
    For tips on how to post your problems[/url]