• Possibly the easiest way would be

    select convert(bigint,+9966557785.0000000000000000)

    Depends on what you want to do with the number after this really though.



    Clear Sky SQL
    My Blog[/url]